Date · Nov 16, 2026

The DAY function,
measured & explained.

DAY pulls the day-of-month out of a date: given 2026-11-16 it returns 16. It reads an Excel date serial and returns a number 1–31, correctly handling month ends and leap days. Use it for day-based grouping, deadlines and date labels.

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

How DAY works

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

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

DAY from real dates

The day-of-month, isolated. Click any row to load it.

Reading the day

ExpressionResultWhy
=DAY(C2)16Day of 2026-11-16
=DAY(C3)1First of the month
=DAY(C5)31Last day of December
=DAY(C8)29Leap day 2024-02-29
=DAY(DATE(2026,11,16))16From a constructed date
=DAY(C2)&"/"&MONTH(C2)&"/"&YEAR(C2)16/11/2026Day-first date label
⚠ DAY is the day of the MONTH (1–31), not the day of the week. For Monday/Tuesday use WEEKDAY (a number) or TEXT(date,"dddd") in real Excel.
DAY returns 1–31 and handles month ends and leap days (2024-02-29 → 29). It reads a date serial or DATE().
// 03 — Try it live

Interactive DAY playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to extract the day 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 DAY works

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

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

Master date

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

  • Reads a date serial or DATE()
  • Returns 1–31, handles leap days
  • Not the weekday — use WEEKDAY
  • DAY ≠ DAYS
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked