Excel EOMONTH Function (Month-End Date) – Examples & Practice
Practice the Excel EOMONTH function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Return the month-end date by shifting start date A2 by the month offset in B2.
Formula Syntax
=EOMONTH(start_date, months)
- start_date: The starting date serial.
- months: How many months to move before returning month-end (0 = current month end).
What it does
EOMONTH returns the last day of the month before or after a specified number of months. It is the standard tool for month-end boundaries in finance models.
Excel EOMONTH Function Examples
Month end from a date
=EOMONTH(A2, 0)
Returns the last day of A2’s month.
Next month end
=EOMONTH(A2, 1)
Moves forward one month, then returns that month-end.
date-calendar.xlsx
| A | B | |
|---|---|---|
| 1 | Date | Offset Months |
| 2 | 2026-01-15 | 0 |
| 3 | 2026-02-28 | 1 |
| 4 | 2026-03-31 | -1 |
| 5 | 2026-07-04 | 2 |
| 6 | 2026-12-20 | 3 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Pair with SUMIFS date criteria for MTD/QTD patterns.
- Store month offsets in clearly named cells.
- Document fiscal calendars if they diverge from EOMONTH defaults.
EOMONTH Function Use Cases
- Accrual periods and month-end close
- Subscription billing windows
- Rolling reporting ranges
- Debt schedules with period boundaries
- KPI windows aligned to calendar months
Common mistakes - EOMONTH function not working
- Confusing months offset with days
- Using text dates as start_date
- Forgetting to format results as dates
- Mixing inclusive/exclusive range policies
- Hard-coding month-end logic that fiscal calendars contradict
FAQ
What does months mean?
months shifts forward (positive) or backward (negative) from start_date before returning month-end.
EOMONTH vs EDATE?
EDATE shifts a date; EOMONTH returns the last day of the shifted month.
Does EOMONTH return a serial?
Yes. Format as a date for display.
Can EOMONTH build month series?
Yes, often dragged with SEQUENCE or helper rows.
Why is my month-end off by one?
Check start_date serial vs visible text and verify months offset sign.
Comparison
| Function | Output |
|---|---|
| EOMONTH | Last day of month |
| EDATE | Same day shifted months |
| DATE | Construct a date |
Example
=EOMONTH(A2,0)
Advanced examples
Month series
Drag =EOMONTH(start, n) across n in a helper row to build a month-end timeline (or use SEQUENCE in modern Excel).