EDATE

Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

EDATE(start_date,months)

Start_date   is a date that represents the start date.

Months   is 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.

Remarks

• If either argument is nonnumeric, EDATE returns the #VALUE! error value.
• If start_date is not a valid date, EDATE returns the #NUM! error value.
• If months is not an integer, it is truncated.

Examples

EDATE(DATEVALUE("01/15/91"),1) equals 33284 or 02/15/91

EDATE(DATEVALUE("03/31/91"),-1) equals 33297 or 02/28/91