Quick Navigation
EOMONTH Function
Summary
The EOMONTH function returns the last day of the month that is a specified number of months before or after a given start date. Perfect for calculating month-end dates, maturity dates, due dates, and fiscal period endings.
Syntax
EOMONTH(start_date, months)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| start_date | Date |
Yes | The reference date. Must be a valid Excel date. |
| months | Number |
Yes | Positive for future months, negative for past months. Non-integers truncated. |
Using the EOMONTH Function
EOMONTH simplifies date calculations by directly returning the last day of any specified month relative to your start date. Use it for loan maturity dates, billing cycles, fiscal month-ends, and report generation schedules.
Common EOMONTH Examples
Next Month End
=EOMONTH("1/15/2024",1)Returns February 29, 2024 (leap year). Shows last day of next month.
Previous Month End
=EOMONTH(A1,-2)Returns last day of the month 2 months before date in A1. Use with cell references.
Fiscal Quarter End
=EOMONTH(TODAY(),2)Returns month-end 2 months from today. Great for planning.
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: start_date not a valid date
Solution: Use DATE(year,month,day) or ensure cell contains proper date
#NUM!
Cause: start_date + months creates invalid date
Solution: Check date range (1900-9999) and validity
#VALUE!
Cause: Text entered instead of date
Solution: Format cells as dates or use DATE function
Notes
- Excel stores dates as serial numbers starting Jan 1, 1900 = 1
- Positive months = future dates, negative = past dates
- Use with TODAY() for dynamic month-ends
- Perfect companion to EDATE for flexible date calculations
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+