Date & Time
Modern
EOMONTH
Returns the last day of the month, a given number of months before or after a date.
Available in All versions (Excel 2007+)
Syntax
EOMONTH(start_date, months)What it returns
The date of the month's last day.
Arguments
| Argument | Required | Description |
|---|---|---|
start_date |
Yes | The starting date. |
months |
Yes | Offset: positive = future, negative = past, 0 = same month. |
Example
Before
2026-06-11
After
2026-06-30
EOMONTH jumps to the last day of the month (here June 30).
=EOMONTH(A2, 0)Important to know
Returns a date serial — format the cell as a date.
months=0 gives the end of the start date's month.
Add 1 day for the first day of next month.