Help

EDATE function to add a month to a given date?

5686 4
cancel
Showing results for 
Search instead for 
Did you mean: 
eminogrande
4 - Data Explorer
4 - Data Explorer

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

4 Replies 4

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

DATEADD(Date, 1, 'months')

More details here:

JB

Laurent_Carpent
4 - Data Explorer
4 - Data Explorer

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

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
4 - Data Explorer
4 - Data Explorer

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