How to Use EDATE Function

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

Formula:

=EDATE(start_date, months)

Explanations:

– 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.

Cautions:

– 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