EDATE function to add a month to a given date?

[eminogrande]

Hello,

i’d like to add X month to a given date. Example

12/31/2019 + 1 month = 12/31/2020

=EDATE(date,months)

How can i do this with Airtable. I got stuck, because there is no EDATE function like in Excel.

Thank you for your help
Emin

[JonathanBowen]

Hi @eminogrande - you can use the DATEADD() function:

DATEADD(Date, 1, 'months')

More details here:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

JB

[Laurent_Carpent]

Hi all,
I have the same question but, instead of wirting the duration (1 in exemple above) I want to refer to a previous column.
I tryed DATEADD({date},{field with duration},‘months’) but it doesn’t work (initial date is displayed)
The field with duration is a lookup from another table and is set as Number, integer format
Any idea?
Thanks for your help,
Laurent

[ScottWorld]

A lookup field is actually an array. You can turn it into a string by adding quotation marks after it like this:

DATEADD({date},{field with duration}&"",'months')

[Laurent_Carpent]

Hi Scott,
It works fine.
I will check the meaning to understand and use it.
Many thanks,
Laurent