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