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(“5/15/2010”,5) returns Oct 31, 2010, the last day of the month five months after May 2010. =EOMONTH(“5/15/2010”,-5) returns Dec 31, 2009, the last day of the month five months before May 2010. |