EOMONTH Formula Generator (2026) — Get Month End Date | Free Excel & Sheets

Returns the last day of the month a specified number of months before or after a date.

Generated Formula
=EOMONTH(start_date, 0)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

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

DATEDIFNOWTODAYNETWORKDAYSYEAR

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More