Description

The EOMONTH function returns the serial number for the last day of the month that is the indicated number of months before or after start_date.

Syntax

EOMONTH (start_date, months)

Argument	Description	Required/ Optional
Start_date	A date that represents the starting date. Dates should be entered by using the DATE function, or as results of other formulas or functions. Problems can occur if dates are entered as text.	Required
Months	The number of months before or after start_date. A positive value for months yields a future date. A negative value yields a past date.	Required

Argument

Description

Required/ Optional

Start_date

A date that represents the starting date.

Dates should be entered by using the DATE function, or as results of other formulas or functions.

Problems can occur if dates are entered as text.

Required

Months

The number of months before or after start_date.

A positive value for months yields a future date.

A negative value yields a past date.

Required

Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900
If months is not an integer, it is truncated.
The result will normally be expressed as a number that can be formatted to represent a Date with Format Cells.
If start_date is not a valid date, EOMONTH returns the #NUM! error value.
If start_date plus months yields an invalid date, EOMONTH returns the #NUM! error value.
If any of the supplied arguments are non-numeric values, EOMONTH returns the #VALUE! error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016