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

Syntax: 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 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:

If you attempt to input a date argument as text, the interpretation of this may differ, depending on the date system and date interpretation settings on your computer.
Although you can enter dates as serial numbers, this is not recommended, as date serial numbering varies across different computer systems.

 

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.

 Formulas:
A B
1 01-Jan-2012 =EOMONTH( A1, 9 )
2 01-Jan-2012 =EOMONTH( A2, -12 )
3 01-Jan-2012 =EOMONTH( A3, 0 )
4 29-Feb-2012 =EOMONTH( A4, 12 )
5 28-Feb-2011 =EOMONTH( A5, 12 )
 Results:
A B
1 01-Jan-2012 31-Oct-2012
2 01-Jan-2012 31-Jan-2011
3 01-Jan-2012 31-Jan-2012
4 29-Feb-2012 28-Feb-2013
5 28-Feb-2011 29-Feb-2012

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.

 

Eomonth Function Errors

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

#VALUE! – Occurs if either any of the supplied arguments are not numeric values.
#NUM! – Occurs if either the supplied start_date is not a valid Excel date or the supplied start_date plus the value of the months argument is not a valid Excel date

 

Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment