Return the day of the week for a date as a number.
Syntax
WEEKDAY(serial_number, [return_type])Arguments
serial_numberrequired
The date.
return_typeoptional
Numbering system; 2 makes Monday = 1.
WEEKDAY converts a date into a weekday number (by default 1 = Sunday … 7 = Saturday). Use the return_type argument to make Monday the first day. Handy for grouping by weekday or flagging weekends.
=WEEKDAY(A2, 2)→3Returns 3 for a Wednesday (Mon=1 system).
Reference the date
Point at the date cell.
Choose the numbering
Use 2 for Monday-first counting.
Use =WEEKDAY(A2,2)>5 — TRUE for Saturday and Sunday.