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.
+17Welcome to the Airtable community!
DATEADD({Purchase Date}, 6, 'months')
You can find documentation for all the available formula functions in the formula field reference.
kuovonne wrote:
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!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.