EOMONTH Function
Returns the last day of the month, a given number of months away.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A date (serial number)
Overview
EOMONTH (end of month) returns the last day of a month — the current month with 0, next month with 1, last month with -1.
It handles 28-, 30- and 31-day months and leap years automatically.
Syntax
=EOMONTH(start_date, months) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | Any date in the starting month. |
| months | Yes | 0 for the same month, positive for later months, negative for earlier ones. |
Examples
Example 1 — Month-end for each date
Find the reporting month-end for each transaction.
B2fx=EOMONTH(A2,0)
| A | B | |
|---|---|---|
| 1 | Date | Month end |
| 2 | 3/15/2026 | 3/31/2026 |
| 3 | 2/10/2026 | 2/28/2026 |
| 4 | 2/10/2028 | 2/29/2028 |
=EOMONTH(A2,0) Explain
Example 2 — Payment due at the end of next month
Northstar's terms are "end of month following".
B2fx=EOMONTH(A2,1)
| A | B | |
|---|---|---|
| 1 | Invoice date | Due |
| 2 | 3/15/2026 | 4/30/2026 |
| 3 | 12/3/2026 | 1/31/2027 |
=EOMONTH(A2,1) Explain
Common mistakes
- The result shows as a number. Format the cell as Short Date.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.