Help

Formula for Calculating six month from a specific date

Topic Labels: Formulas
2113 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Keith_Greer
4 - Data Explorer
4 - Data Explorer

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!