EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months
Syntax
EOMONTH(start_date, months)
Parameters
- start_date: Required. A date that represents the starting date
- months: Required. The number of months before or after start_date
Example
=EOMONTH("1/15/2024", 1)