Formula Request: Date + Months = Future Date


#1

Hi,

I hope someone can help me. A the moment I have 3 columns:
Date Opened | Months | Expires

In the first column “Dates Opened” I have dates in the format DD/MM/YYYY and they will always be a date in the past or today. Th field type for this column is Dates.

In the second column “Months” I have integer numbers. These numbers represent months. So the value 6 will be 6 months, etc. The field type for this column is Number

Now the third column “Expires” is where I would like to place the formula. I would like to get the date from the first column, and add x amount of months to it to create a new date in the format DD/MM/YYYY. So if the value of the second column is 6, I would like the third column to have a value where 6 months was added.

I hope that makes and would appreciate any help! I’ve attached a screenshot with example values.

I can see from here that it can be done with EDATE in Excel, but can’t see support for that in AirTable.

Thanks


#2

You can use DATEADD function: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#date_and_time_functions

I leave an example: https://airtable.com/shrZnz5DWdu5r4ZB3


#3

Oh, my bad for missing that. It worked perfectly, thank you!