EOMONTH


Returns the date of the last day of a month.

Syntax:

EOMONTH(startdate, addmonths)
addmonths is a number of months to be added to the startdate (given as text or a date-time serial number), to give a new date. For this new date, EOMONTH returns the date of the last day of the month, as a date-time serial number. addmonths may be positive (in the future), zero or negative (in the past).

Example:

EOMONTH("2008-02-14", 0)
returns 39507, which may be formatted as 29 Feb 08. 2008 is a leap year.
EOMONTH(A1, 2)
where cell A1 contains the date 16 Dec 07, again returns 39507, which may be formatted as 29 Feb 08.






 
Created with Zapof