The EOMONTH function returns the last day of a month based on a given date. It is very useful for financial reports, monthly summaries, and deadline calculations.
Structure of EOMONTH
=EOMONTH(start_date, months)
Arguments:
- start_date → The reference date
- months → Number of months before or after the start date
How It Works
- If months = 0 → Returns end of the same month
- If months = 1 → Returns end of next month
- If months = -1 → Returns end of previous month
Example 1: End of Current Month
If A1 contains:
24-Feb-2026
Formula:
=EOMONTH(A1,0)
Result:
28-Feb-2026
Example 2: End of Next Month
=EOMONTH(A1,1)
Result:
31-Mar-2026
Example 3: End of Previous Month
=EOMONTH(A1,-1)
Result:
31-Jan-2026
Practical Uses of EOMONTH
It helps you:
- Calculate monthly deadlines
- Generate month-end financial reports
- Determine salary cutoff dates
- Create billing cycles
- Manage accounting periods
Example: Calculate Last Date of Current Month Automatically
=EOMONTH(TODAY(),0)
This always shows the last date of the current month.
Important Notes
- Dates must be valid Excel dates.
- You can format the result as Date if needed.
- Negative values move backward in time.
Why EOMONTH is Important
It simplifies monthly date calculations and is widely used in finance, accounting, HR, and reporting tasks.
The EOMONTH function is essential for managing month-end processes efficiently in Excel.