What it does
EOMONTH returns the last day of the month, a number of months before or after a date.
Syntax or pattern
=EOMONTH(start_date, months)✅
5 practical examples
1
End of current month
Return the month-end for a date.
=EOMONTH(A2,0)Useful for period grouping.
2
End of next month
Return the next month-end.
=EOMONTH(A2,1)Change the month offset.
3
End of previous month
Return previous month-end.
=EOMONTH(A2,-1)Negative offsets go backward.
4
Monthly report label
Create a month-end label.
=TEXT(EOMONTH(A2,0),"mmm yyyy")Combines date logic with TEXT.
5
Days until month end
Calculate days remaining in the month.
=EOMONTH(TODAY(),0)-TODAY()Good for countdowns and planning.
Common mistakes to avoid
- Check whether dates are real Excel dates, not text.
- Be careful with weekends, holidays and time portions.
- Explain whether a result counts calendar days or workdays.
Related Excel examples
FAQ
Why does the date formula return a number?
Excel stores dates as serial numbers. Format the cell as a date to display it correctly.