Excel EOMONTH Function

Excel EOMONTH Function


Get the last day of the month in future or past months

Return value 

A serial number that represents a particular date in Excel.


=EOMONTH (start_date, months)


  • 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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas