Documentation/How Tos/Calc: EOMONTH function

From Apache OpenOffice Wiki
Jump to: navigation, search



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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_EOMONTH_function&oldid=243347"
Views
Personal tools
Navigation
Print/export
Tools