WEEKDAY
Converts a serial number to a day of the week.
Date & TimeDates & Time CalculationsMost Used
What it does
Returns the day-of-week number for a date (with configurable numbering).
Syntax
WEEKDAY(serial_number, [return_type])
Arguments
serial_number(date) — Date to evaluate.return_type(number) — Defines the numbering scheme (optional).
Examples
Day of week (Mon=1)
Return weekday number with Monday as 1.
FORMULA
=WEEKDAY(A2,2)
RESULT
5
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-03-13 |
| 3 | 2026-03-14 |