The Excel EOMONTH Function

Home » Excel-Built-In-Functions » Excel-Date-And-Time-Functions » Excel-Eomonth-Function Search this site: Custom Search

Related Function:  EDATE

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:

where the arguments are as follows:

Note that, when supplying a date to a function, this should be input as either:

• A reference to a cell containing a date

• A date returned from another function or formula

Warning:

Eomonth Function Examples

The following spreadsheet shows examples of the Eomonth function.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Note how you can use negative values for the months argument, to get a date that is before the supplied start_date. You can also set the months argument to zero, to get the last day of the original start_date.

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 :