Documentation/Calc Functions/EOMONTH

Function name:
EOMONTH

Category:
Date and Time

Summary:
Calculates the date of the last day in the month that is a specified number of months before or after a given date. EOMONTH can be used to determine different types of end / due date that fall at the end of the month.

Syntax:
EOMONTH(StartDate; Months)

Returns:
Returns an integer date-time serial number which represents the new date. The returned value is formatted as a number by default, but you can apply other formats as needed.

Arguments:
StartDate is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the start date for which the calculation is to be carried out.

Months is an integer value or a reference to a cell containing that value, which is the number of months to be added to StartDate. Positive, zero, and negative values are accepted. Negative values result in dates that are earlier than StartDate, while positive values result in dates that are later than StartDate.


 * If StartDate does not contain a valid date expression, then EOMONTH reports a #VALUE! error.
 * EOMONTH ignores any time components of StartDate. Also, the day component of StartDate is not significant to EOMONTH’s calculation.
 * If Months is non-numeric, then EOMONTH reports a #VALUE! error.
 * If Months is a non-integer value, then EOMONTH truncates it to an integer.

Related LibreOffice functions:
EDATE

ODF standard:
Section 6.10.9, part 2

Equivalent Excel functions:
EOMONTH