WEEKDAY pitfall 1: Default scheme is 1 (Sun=1..Sat=7)?

Default scheme is `1` (Sun=1..Sat=7). For ISO weeks (Mon=1..Sun=7) pass `2` as the second argument.

WEEKDAY pitfall 2: Returns a NUMBER, not a day name?

Returns a NUMBER, not a day name. Wrap in `CHOOSE` or `TEXT(date, "ddd")` for human-readable output.

Dateeasy

Returns the day of the week for a date, as a number (default Sunday=1, Saturday=7).

Syntax

=WEEKDAY(date, [type])

Arguments

Argument	Description
date	The date to query.
[type]	Numbering scheme: 1 = Sun(1)..Sat(7) [default], 2 = Mon(1)..Sun(7), 3 = Mon(0)..Sun(6).

Example

=WEEKDAY("2026-05-07")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and WEEKDAY isn't one of them yet.

Default scheme is 1 (Sun=1..Sat=7). For ISO weeks (Mon=1..Sun=7) pass 2 as the second argument.
Returns a NUMBER, not a day name. Wrap in CHOOSE or TEXT(date, "ddd") for human-readable output.

Related formulas

Used by