Date & time · month-end · Nov 16, 2026

The EOMONTH function,
measured & explained.

EOMONTH returns the last day of a month, n months away — leap-year aware. EDATE keeps the day-of-month instead. This page measures month-ends, leap-year February, and the EOMONTH/EDATE contrast live.

D1
fx
=EOMONTH(DATE(2024,1,15), 0)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How EOMONTH works

Returns the last day of the target month as a serial; leap-year aware. Wrap in TEXT to display a format.

=EOMONTH(start_date, months)
start_dateThe reference date.
monthsMonths to shift: 0 same month, +1 next, -1 prior.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Month-end & leap

What EOMONTH actually returns

EOMONTH returns the last day of a month, n months away — leap-year aware. EDATE keeps the day-of-month instead. Every row measured live. Click any row to load it.

Month-end gallery

ExpressionResultWhy
=TEXT(EOMONTH(DATE(2024,1,15),0),"yyyy-mm-dd")2024-01-31Last day of the same month
=TEXT(EOMONTH(DATE(2024,2,5),0),"yyyy-mm-dd")2024-02-29Leap-year February ends on 29
=TEXT(EOMONTH(DATE(2023,2,5),0),"yyyy-mm-dd")2023-02-28Non-leap February ends on 28
=TEXT(EOMONTH(DATE(2024,1,31),1),"yyyy-mm-dd")2024-02-29Last day of the next month
=TEXT(EOMONTH(DATE(2024,3,15),-1),"yyyy-mm-dd")2024-02-29Last day of the prior month
=TEXT(EDATE(DATE(2024,1,15),1),"yyyy-mm-dd")2024-02-15EDATE keeps the day-of-month
=TEXT(EDATE(DATE(2024,1,15),-1),"yyyy-mm-dd")2023-12-15EDATE one month back
=EOMONTH(DATE(2024,1,15),0)45322The month-end serial number

EOMONTH vs EDATE

ExpressionResultWhy
=TEXT(EOMONTH(DATE(2024,1,15),0),"yyyy-mm-dd")2024-01-31EOMONTH → last day of month
=TEXT(EDATE(DATE(2024,1,15),1),"yyyy-mm-dd")2024-02-15EDATE → same day, next month
⚠ EOMONTH always lands on the last day (Jan 31, Feb 28/29); EDATE keeps the day-of-month. February's end depends on the leap year: 2024→29, 2023→28. Both return serials — wrap in TEXT to display.
months=0 is the current month-end, +1 next month, -1 prior month. For due dates and billing periods use EOMONTH; for anniversaries that keep the day use EDATE.
// 03 — Try it live

Interactive EOMONTH playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see EOMONTH land on month-end, handle leap-year February, and contrast with EDATE's same-day shift.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where EOMONTH works

EOMONTH and EDATE are available in Excel 2003+, Microsoft 365, Excel for the web and Google Sheets. This page uses EDATE only on mid-month dates; EDATE's leap-year day-clamp differs across engines, so month-end work uses EOMONTH.

PlatformSupportNotesGotcha
✓ Supported full EOMONTH◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master month-end dates

EOMONTH is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Month-end for billing and due dates
  • Leap-year February (28 vs 29)
  • EOMONTH vs EDATE
  • months = 0 / +1 / -1
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked