EDATE function to add a month to a given date?

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

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

DATEADD(Date, 1, 'months')

More details here:

JB

1 Like