Description
Returns the serial number that represents the date that is the indicated number of months before or after a specified date.
Syntax
EDATE ( StartDate, months )
| Parameter | Description |
|---|---|
| StartDate | A date that represents the start date. |
| months | The number of months before or after StartDate. A positive value for months yields a future date; a negative value yields a past date. |
Remarks
Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. If StartDate is not a valid date, EDATE returns the #NUM! error value. If months is not an integer, it is truncated.
Examples
EDATE(DATEVALUE("6/5/2014"),3) equals 41887, or Sept. 5 2014.
EDATE("6/5/2014", -6) ) equals 41613.
Use the TEXT function to convert the serial number back into a date; for example:
TEXT(EDATE("6/5/2014",-6),"MM/DD/YYYY") returns 12/05/2013.
See also