Purpose
Get the last day of the month in future or past months
Return value
A serial number that represents a particular date in Excel.
Syntax
=EOMONTH (start_date, months)
Arguments
- start_date - A date that represents the start date in a valid Excel serial number format.
- months - The number of months before or after start_date.
Usage notes
For months, use a positive value for future dates and a negative value for dates in the past.
If you receive a #NAME? error when trying to use this function, install and load the Analysis ToolPak add-in.