EOMONTH function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
EOMONTH
Returns the date of the last day of a month.
This function is only available if the Analysis AddIn is installed.
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 29Feb08. 2008 is a leap year.
EOMONTH(A1; 2)
- where cell A1 contains the date 16Dec07, again returns 39507, which may be formatted as 29Feb08.
See Also
