Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Excel how-to guide
How to eomonth last day in Excel
Set billing period end dates, calculate quarter-end dates, or find the last day of any month without knowing whether it has 28, 29, 30, or 31 days.
Step-by-step instructions
How to eomonth last day — 3 steps
1
Enter a date in column A — any date within the month you want.
2
Use 0 as the second argument to get the last day of that same month.
3
Use 1 for next month, -1 for the previous month, and so on.
Example data
Worked example
| Any Date in Month | Last Day of Month |
|---|---|
| 2026-02-10 | 2026-02-28 |
| 2026-03-01 | 2026-03-31 |
| 2026-04-15 | 2026-04-30 |
Common mistakes
Errors to watch out for
Result displays as a number
EOMONTH returns a date serial number. Format the result cell as a Date to display it correctly.
Off by one month
EOMONTH(A2,0) returns the last day of the month containing A2, not the last day of the next month. Use 1 to get the last day of the following month.
FAQ
Frequently asked questions
How do I get the first day of the next month?
Add 1 to EOMONTH — =EOMONTH(A2,0)+1 gives you the first day of the month following the date in A2.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Date & Timeintermediate
Calculate a due date skipping weekends with WORKDAY
=WORKDAY(A2,30)