# The Excel EOMONTH Function

Related Function:
EDATE

## Function 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 (positive or negative) to add to the start_date, before returning the last day of the resulting month.

### Date Arguments

Note that it is advised that you do not type dates directly into functions, as Excel interprets text representations of dates differently, depending on the date interpretation settings on your computer.

Therefore the start_date argument for the Eomonth function should be input as either:

• A reference to a cell containing a date
or
• A date returned from another function or formula.

## Eomonth Function Examples

Column B of the following spreadsheet shows several examples of the Eomonth function.

Formulas:
AB
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 )
Results:
AB
101-Jan-201231-Oct-2012
201-Jan-201231-Jan-2011
301-Jan-201231-Jan-2012
429-Feb-201228-Feb-2013
528-Feb-201129-Feb-2012

The above examples show that:

• 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 month of the original start_date.

For further examples of the Excel Eomonth function, see 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
 #NUM! - Occurs if either:The supplied start_date is not a valid Excel dateorThe 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.