EOMONTH formula provides last date of the month as per given parameter.

Syntax of EOMONTH  formula

EOMONTH( start_date, months )

Parameters or Arguments

start_date: The starting date to use in the calculation.
months: The number of months to add to the start_date. It can be a positive or negative value.


The EOMONTH function returns a date which will be the last date of the month.

EOMONTH Formula Example
EOMONTH Formula Example