WEEKDAY
The WEEKDAY function returns a number representing the day of the week for a given date.
Syntax
=WEEKDAY(serial_number, [return_type])
Parameters
serial_number
: The date for which you want to find the day of the weekreturn_type
: Optional. A number that determines the type of return value:- 1 (default): Numbers 1 (Sunday) through 7 (Saturday)
- 2: Numbers 1 (Monday) through 7 (Sunday)
- 3: Numbers 0 (Monday) through 6 (Sunday)
Examples
=WEEKDAY("2025-04-21") // Returns 2 (Monday with default return_type)
=WEEKDAY("2025-04-21", 2) // Returns 1 (Monday when return_type is 2)
=WEEKDAY(TODAY()) // Returns the weekday number for current date