Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for Calculating six month from a specific date

Topic Labels: Formulas
169 2
Showing results for 
Search instead for 
Did you mean: 

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.

2 Replies 2

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.

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!