EDATE function to add a month to a given date?


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

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


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

Thank you for your help

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

DATEADD(Date, 1, 'months')

More details here:


1 Like