EOMONTH ^v2.6.131 ​

Calculates the last day of the month that is the specified number of months before or after a given date.

EOMONTH(start_date, months)

EOMONTH(start_date, months)

Parameters ​

• start_date - The start date or time value, represented as an Excel date value.
• months - The number of months before or after the start date.

Examples ​

EOMONTH("2022-04-17", 2)

EOMONTH("2022-04-17", 2)

Result: 44742

Note: Calculates the last day of the month that is 2 months after the start date (2022-04-17).

EOMONTH(45033, -1)

EOMONTH(45033, -1)

Result: 45016

Note: Calculates the last day of the month that is 1 month before the start date (45033).