Formulas and Functions
Modifying this control will update this page automatically

EOMONTH

The EOMONTH function returns a date/time value that is the last day of the month, some number of months before or after a given date.

EOMONTH(start-date, month-offset)

start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.

month-offset: The number of months before or after the starting date. month-offset is a number value. A negative month-offset is used to specify a number of months before the starting date and a positive month-offset is used to specify a number of months after the starting date.

Examples

=EOMONTH("15/5/2010",5) returns 31 Oct 2010, the last day of the month five months after May 2010.

=EOMONTH("15/5/2010",-5) returns 31 Dec 2009, the last day of the month five months before May 2010.

See alsoEDATE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.