Date · Nov 16, 2026

The MONTH function,
measured & explained.

MONTH pulls the month out of a date: given 2026-11-16 it returns 11. Like YEAR and DAY it reads an Excel date serial and returns a plain number 1–12. Use it to group by month, build month labels, or drive seasonal logic.

D1
fx
=MONTH(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How MONTH works

Returns a number 1–12. The month of the given date.

=MONTH(serial_number)
serial_numberThe date (as a serial or DATE() result) whose month to return.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Extract the month

MONTH from real dates

The middle part of a date. Click any row to load it.

Reading the month

ExpressionResultWhy
=MONTH(C2)11Month of 2026-11-16
=MONTH(C3)1January
=MONTH(C5)12December
=MONTH(C8)2February of a leap year
=MONTH(DATE(2026,11,16))11From a constructed date
=TEXT(C2,"yyyy")&"-"&TEXT(C2,"mm")2026-11Zero-padded year-month
⚠ MONTH returns a number 1–12, not a name. For "Nov" use TEXT(date,"mmm") in real Excel — the live engine does not implement month names.
MONTH returns 1 (January) to 12 (December). It reads a date serial or DATE(). For a zero-padded month string use TEXT(date,"mm").
// 03 — Try it live

Interactive MONTH playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to extract the month from a date.

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 MONTH works

MONTH is a core date function present in every Excel version and platform.

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

Master date

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

  • Reads a date serial or DATE()
  • Returns 1 (Jan) to 12 (Dec)
  • Names need TEXT (Excel-only)
  • Pair with YEAR and DAY
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked