How to Use EDATE Function

The EDATE function returns the date before or after the specified months.


=EDATE(start_date, months)


– Start_date is required, the start date you need to have the date months before or after.

– Months is required, the number of months you specified.


– Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.

– When the month is not an integer, it is truncated to use the integer.

Leave a Reply