Microsoft® Excel® 2010 Formulas & Functions Inside Out

EDATE()

Note

In Excel 2003, this function is available as an add-in.

Syntax. EDATE(start_date,months)

Definition. This function returns the serial number of the date that is the indicated number of months before or after the start date.

Arguments

• start_date (required). The date that represents the start of the calculation.

• months (required). Indicates the number of months before or after the start date. A positive value for the months returns a future date, and a negative value returns a past date.

Background. The EDATE() function calculates the date for the specified number of months before or after the start date. Alternatively, you can use the YEAR(), MONTH(), and DAY() functions to divide the start date into three parts. Increase the month value ...