EDATE function.Get a date (serial value) after the specified month, taking into account the last day of the month.(Microsoft Excel)

06/22/2024

Japanese version.

Get a date (serial value) after the specified month, taking into account the last day of the month.

How it works

=EDATA(Start_date,Months)
ArgumentOmissionSpecify
Start_dateRequired argument.Target date for the calculation.
MonthsRequired argument.Number of months to be added.
Positive number for future, negative number for past.

Example Results

These are the results of executing the EDATE and DATE functions by argument.

FunctionFormura
EDATE=EDATE(Start_date,Months)
DATE=DATE(YEAR(Start_date),MONTH(Start_date)+Months,DAY(Start_date))

Patterns with different result dates have a yellow background color.

To add one month to January 31, the EDATE function takes into account the difference in the last day of the month and returns 2/28 as the result.
The DATE function adds 31 days and the result is 3/3.

---

Links

Date & Time(Microsoft Excel Functions)

How to calculate dates.(Microsoft Excel)