Excel EOMONTH Function: Complete Guide (2026)
Home›Functions›Date & Time›EOMONTH
ExcelFunction Reference⏱ 5 min read

Excel EOMONTH Function: Complete Guide

EOMONTH — end of month — returns the last day of the month N months away from a start date. It's the workhorse for month-end reporting, invoice due dates, and any calculation that anchors to the last calendar day of a period.

Syntax

EOMONTH(start_date, months)
ArgumentTypeDescription
start_date RequiredDateThe anchor date. Any day of the month — EOMONTH returns the last day regardless of your input day.
months RequiredNumberHow many months to move forward (positive) or backward (negative). 0 = same month.

Basic examples

End of current month

=EOMONTH(TODAY(), 0)
If today = Sep 6, 2026 → Result: September 30, 2026

End of next month

=EOMONTH(TODAY(), 1)
Result: October 31, 2026

End of prior month

=EOMONTH(TODAY(), -1)
Result: August 31, 2026

End of month 6 months out

=EOMONTH(TODAY(), 6)
Result: March 31, 2027

Common uses

1. First day of the month

Getting to the first of a month

=EOMONTH(A1, -1) + 1
If A1 = any day in September → Result: September 1, 2026

2. First day of next month

Month-boundary math

=EOMONTH(A1, 0) + 1
End of A1's month + 1 day = first of next month

3. Days remaining in month

Days until month-end

=EOMONTH(TODAY(), 0) - TODAY()
Format as Number to see the day count

4. Month-end grouping for a PivotTable

Bucket transactions by month-end

=EOMONTH(A1, 0)
Applied to a transaction date column, this groups every row into its month-end. PivotTable rows by this column show clean month-by-month buckets.

5. Quarter-end date

End of current calendar quarter

=EOMONTH(TODAY(), MOD(3 - MOD(MONTH(TODAY()), 3), 3))
If today = Sep 6 → Result: September 30, 2026 (end of Q3)

6. Fiscal quarter-end (April-start FY)

End of fiscal quarter for AU/UK FY

=EOMONTH(A1, MOD(3 - MOD(MONTH(A1) - 4, 3), 3))
Shifts the quarter math by 3 months to align with April fiscal start.

7. Payment due date (Net 30 to month-end)

End of following month

=EOMONTH(A1, 1)
Common "Net 30 EOM" invoice terms — payment due on the last day of the month after invoicing.

EOMONTH vs. EDATE — the key difference

InputEDATE(start, 3)EOMONTH(start, 3)
Feb 15, 2026May 15, 2026May 31, 2026
Feb 28, 2026May 28, 2026May 31, 2026
Jan 31, 2026Apr 30, 2026 (clipped)Apr 30, 2026

EDATE preserves the day-of-month (clipping when necessary — Jan 31 + 1 month = Feb 28). EOMONTH always returns the last day.

The month-end anchor pattern

For time-series analysis, aligning everything to month-ends is standard. Add a "Period End" column with =EOMONTH([Date], 0). Now:

  • PivotTables group cleanly by month
  • Multi-period comparisons align by month-end
  • Aggregations don't fragment across month boundaries

Common pitfalls

Serial number result instead of a date

If EOMONTH returns 46326 instead of "September 30, 2026", the cell is formatted as Number or General. Right-click → Format Cells → Date.

Confusion with the day-of-month

EOMONTH ignores the day part of start_date. EOMONTH("2026-09-06", 0) and EOMONTH("2026-09-30", 0) both return Sep 30. This is intentional but can surprise you.

Combine EOMONTH with COUNTIFS for month-based tallies

To count transactions in a specific month regardless of day: =COUNTIFS(dateColumn, ">="&EOMONTH(A1,-1)+1, dateColumn, "<="&EOMONTH(A1,0)). Anchoring both bounds to EOMONTH prevents day-boundary bugs.

EOMONTH in Google Sheets

Google Sheets has an identical EOMONTH function. Same syntax, same behavior. In Google Sheets you can also use QUERY with date functions for more complex month-end reporting.

Related functions

Related

EDATE

Same but preserves the day-of-month.

Related

DATE

Construct dates from components.

Related

TODAY

Common EOMONTH input for "current month".

Related

NETWORKDAYS

Business days in a month.

Excel Wizard

Month-end math without the head-scratching

Getting the first day of a month, the last day, or the end of a fiscal quarter each requires a slightly different EOMONTH pattern. Excel Wizard handles it — describe what you need ("last day of the quarter") and it writes the right EOMONTH combo.

Install Excel Wizard →

Frequently asked questions

What does EOMONTH do in Excel?

EOMONTH returns the last day of the month N months from a start date. Syntax: =EOMONTH(start_date, months).

How do I get the last day of the current month?

Use =EOMONTH(TODAY(), 0). Returns the last day of the current month.

How do I get the first day of a month?

Use =EOMONTH(A1, -1) + 1. EOMONTH with -1 gives the last day of the previous month; adding 1 gives the first day of the current month.

What's the difference between EOMONTH and EDATE?

EDATE returns the same day of the month N months later. EOMONTH returns the last day of that month. Use EDATE for anniversaries; EOMONTH for month-end reporting.