What is WEEKDAY?
Returns the day of the week for a date as a number. Essential for scheduling, work week calculations, and conditional formatting.
Syntax
=WEEKDAY(date, [return_type])
Example
Formula: =WEEKDAY(A1)
Result: 5 (Thursday)
How It Works
Returns day of week (1-7). Default: Sunday=1, Saturday=7. return_type 2: Monday=1, Sunday=7. Perfect for work week calculations.