Calc EOMONTH function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The EOMONTH function helps you find the last day of the month for a given date. This can be useful for determining due dates, deadlines, or maturity dates that always fall at the end of a month.

Syntax

EOMONTH(date)

The EOMONTH function syntax has the following arguments:

• date Required. Dates should be entered either by using the "YYYY-MM-DD" format by using the DATE function, or as results of other formulas or functions.

Remarks

• The function calculates the last day of the month for the date that is 'months' away from 'start_date'.
  • For instance, EOMONTH(DATE(2020, 1, 15), 1) gives you the last day of February 2020, since that's one month after January 15, 2020.
  • EOMONTH(DATE(2020, 1, 15), -2) gives you the last day of November 2019, which is two months before January 2020.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc DATE function
• Calc DATEDIF function
• Calc DATESUB function
• Calc DAY function
• Calc DAYS function