EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months.
Date & TimeDates & Time Calculations
What it does
Returns the last day of the month, n months in future/past.
Syntax
EOMONTH(start_date, months)
Arguments
start_date(date) — The starting date.months(number) — Months to add/subtract.
Examples
End of Month
End of month, 1 month later.
FORMULA
=EOMONTH(A2, 1)
RESULT
2023-02-28
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2023-01-15 |