Functions
WEEKDAY
Day of week as a number
Try it
When to use it
When should I use WEEKDAY instead of DAY?
Use WEEKDAY to get the day of the week (1-7) from a date; use DAY for the day-of-month number.
What does the second argument of WEEKDAY control?
It sets which day counts as 1. The default (1) starts the week on Sunday; type 2 starts it on Monday.
Use cases
Use Monday-start numbering for scheduling
Flag whether a date is a weekend
Used in
operations · hr
Syntax
WEEKDAY(date,[type])Examples
=WEEKDAY(DATE(1969,7,20)) // => 1
=WEEKDAY(40909) // => 1
=WEEKDAY(40909,3) // => 6