Date · Nov 16, 2026

The WEEKDAY function,
measured & explained.

WEEKDAY tells you which day of the week a date falls on, as a number. The crucial detail is return_type: by default Sunday is 1, but return_type 2 makes Monday 1 (the ISO convention) and return_type 3 makes Monday 0. Choosing the wrong return_type is the single most common WEEKDAY mistake.

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

How WEEKDAY works

Returns a number. The weekday under the chosen return_type scheme; invalid return_type returns #NUM!.

=WEEKDAY(serial_number, return_type)
serial_numberThe date (as a serial or DATE() result) whose weekday to return.
return_typeOptional. 1 = Sun=1 (default), 2 = Mon=1, 3 = Mon=0.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — return_type

Three numbering schemes

Same Monday, three different numbers. Click any row to load it.

Choosing the numbering

ExpressionResultWhy
=WEEKDAY(C2)2Default: Sun=1, so Monday=2
=WEEKDAY(C2,1)2return_type 1: Sun=1..Sat=7
=WEEKDAY(C2,2)1return_type 2: Mon=1..Sun=7
=WEEKDAY(C2,3)0return_type 3: Mon=0..Sun=6
=WEEKDAY(C7,2)7Sunday under Mon=1
=WEEKDAY(C3,1)5Thursday under Sun=1
⚠ The default (return_type 1) makes SUNDAY=1, so Monday=2. If you expect Monday=1 you must pass return_type 2. An invalid return_type like 9 returns #NUM!.
return_type 1: Sun=1..Sat=7 (default). 2: Mon=1..Sun=7 (ISO). 3: Mon=0..Sun=6. For a weekday name use TEXT(date,"dddd") in real Excel.
// 03 — Try it live

Interactive WEEKDAY playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare the three return_type schemes.

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

WEEKDAY is a core date function present in every Excel version; return_type options 1–3 are universal.

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

Master date

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

  • Default Sun=1; return_type 2 = Mon=1 (ISO)
  • return_type 3 = Mon=0 (zero-based)
  • Invalid return_type → #NUM!
  • Names need TEXT (Excel-only)
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked