EOMONTH in Excel: Find Last Day of the Month Fast
Returns the last day of the month a specified number of months before or after a date.
How to Find Month-End Dates with EOMONTH in Excel
The EOMONTH function returns the last day of the month that is the indicated number of months before or after a start date.
Syntax
=EOMONTH(start_date, months)
Common Applications
- Last Day of Current Month:
=EOMONTH(TODAY(), 0) - First Day of Next Month:
=EOMONTH(TODAY(), 0) + 1
Common Errors & Fixes
#NUM! or #VALUE! error
Causes:- Start date is not a valid date.
- Month offset is non-numeric or the resulting date is invalid (e.g., year beyond Excel limits).
Fixes:- Ensure the start date cell contains a valid date.
- Validate the months argument is a number within a reasonable range.
Frequently Asked Questions
What is EOMONTH used for?
EOMONTH returns the last day of the month, given a starting date and month offset. It is commonly used for financial reporting, invoice due dates, and subscription billing cycles.
What does months = 0 do?
EOMONTH(A1, 0) returns the last day of the month for the date in A1. For example, EOMONTH("2026-05-14", 0) returns May 31, 2026.
Does EOMONTH work in Google Sheets?
Yes, EOMONTH works identically in Google Sheets with the same syntax. It is fully compatible between both platforms.
Related Formulas
Explore related formula generators to solve similar problems
🛠️ Related Tools
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More