Skip to main content

Formula Request: Date + Months = Future Date

  • December 2, 2017
  • 2 replies
  • 37 views

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 replies

Forum|alt.badge.img+17

  • Author
  • New Participant
  • December 2, 2017

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


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