EOMONTH Function in Excel
Intermediate
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date.
Syntax
=EOMONTH(start_date, months)Example
Use Case
Find the due date at the end of the month.
Common Errors to Avoid
- Returns #NUM! if start_date is invalid
- Months parameter can be positive (future) or negative (past)
- Returns last day at exact time, not beginning of day
Pro Tips
Use months=0 to get the last day of the current month. Add 1 to result to get first day of next month: =EOMONTH(A1,0)+1. Format cell as date to display properly.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →