EDATE

Description Finds a date a specified number of months before or after a given date. This is useful for computing dates associated with securities.

Syntax EDATE ( start_date, months)

Argument Description

start_date Any date. Dates in the argument list must be in the form of a serial number or text.

months The number of months after or before start_date. Enter a negative number for months before, a positive number for months after. Decimal values are truncated to integers.

Argument	Description
start_date	Any date. Dates in the argument list must be in the form of a serial number or text.
months	The number of months after or before start_date. Enter a negative number for months before, a positive number for months after. Decimal values are truncated to integers.

Examples This function returns 4/15/99:

EDATE("2/15/99",2)

See Also EOMONTH