The Excel EOMONTH Function

Related Function:

Basic Description

The Excel Eomonth function returns the last day of the month, that is a specified number of months before or after an initial supplied start date.

The syntax of the function is:

EOMONTH( start_date, months )

where the arguments are as follows:

start_date-The initial date.
months-The number of months to add to (or subtract from) the start_date, before returning the last day of the resulting month.

Note that, when supplying the start_date to the function, this should be input as either:


Warning: If you attempt to input Excel date arguments as text, the interpretation of the date may differ, depending on the date system and date interpretation settings on your computer.

Eomonth Function Examples

The following spreadsheet shows examples of the Eomonth function.

101-Jan-2012=EOMONTH( A1, 9 )
201-Jan-2012=EOMONTH( A2, -12 )
301-Jan-2012=EOMONTH( A3, 0 )
429-Feb-2012=EOMONTH( A4, 12 )
528-Feb-2011=EOMONTH( A5, 12 )

The above examples show how:

Further examples of the Excel Eomonth function can be found on the Microsoft Office website.

Eomonth Function Errors

If you get an error from the Excel Eomonth function this is likely to be one of the following:

Common Errors

Occurs if either:

  • the supplied start_date is not a valid Excel date
  • the supplied start_date plus the value of the months argument is not a valid Excel date.
#VALUE!-Occurs if any of the supplied arguments are non-numeric values.