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.
Returns
The EOMONTH function returns a date which will be the last date of the month.