Skip to main content

Formula for Calculating six month from a specific date


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

kuovonne
Forum|alt.badge.img+17
  • Brainy
  • 5987 replies
  • August 5, 2022

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.


  • Author
  • New Participant
  • 1 reply
  • August 5, 2022
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