Excel EDATE() function

Last update on August 19 2022 21:50:55 (UTC/GMT +8 hours)

EDATE() function

This function is used to return the serial number that represents the date that is the indicated number of months before or after a specified date.

Version: Excel 2013

Syntax:

EDATE(start_date, months)

Parameters:

Name	Description	Data Type	Required/ Optional
Start_date	A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions.	Date	Required
Months	The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.	Date	Required

Remarks:

Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2010, is serial number 40179 because it is 40178 days after January 1, 1900.
when start_date is not a valid date, EDATE returns the #VALUE! error value.
when months is not an integer, it is truncated.

Example - 1:

The example below finds the date, one month after the date as shown in A2.