Logo Docs
Logo Docs

EOMONTH

Returns the last day of the month for a given date (End Of MONTH)

Usage

EOMONTH(date)

Parameters

date

(Required) The date from which to determine the end of the month

Examples

Example With these variables Result

EOMONTH(current_date)
current_date is DATE(2024, 1, 12)

DATE(2024, 1, 31)

EOMONTH(DATE(2023, 2, 15))

 (None)

DATE(2023, 2, 28)

More information

The function returns the last day of the month for the given end_date.

The name comes from “End Of MONTH”.

Reminders

A text containing a date is not handled as a date. To have an actual date:

  • use the @DATE_QUESTION to set the variable
  • use a function that converts to a date: DATEVALUE(text_date)
  • use a function that returns a date: TODAY() or DATE(year, month, day)

See also