EOMONTH

Returns the serial number date for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

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

EOMONTH(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, EOMONTH returns the #VALUE! error value.
• If start_date is not a valid date, EOMONTH returns the #NUM! error value.
• If months is not an integer, it is truncated.
• If start_date plus months yields an invalid date, EOMONTH returns the #NUM! error value.

Examples

EOMONTH(DATEVALUE("01/01/93"), 1) equals 34028 or 2/28/93

EOMONTH(DATEVALUE("01/01/93"), -1) equals 33969 or 12/31/92