Formula for Calculating six month from a specific date

[Keith_Greer]

Hope you can help. I have a table to record customers and products purchased. Each product comes with 6 months warranty. In the table I have a date of purchase column. I need another column that displays how many days of their 6 month warranty are left since the date of purchase. My question is: is there a formula that can do this? Many thanks in advance.

[kuovonne]

Welcome to the Airtable community!

DATEADD({Purchase Date}, 6, 'months')

You can find documentation for all the available formula functions in the formula field reference.

[Keith_Greer]

Hi Kuovonne, Thanks so much for the quick reply. I had looked briefly at the documentation but was not sure exactly what I needed. I will try your formula. I really appreciate your help.

Many thanks again!