Google Sheets Function

WEEKDAY

Return the day of the week for a date as a number.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

WEEKDAY(serial_number, [return_type])

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.

Arguments

serial_numberrequiredThe date.
return_typeoptionalNumbering system; 2 makes Monday = 1.

Examples

=WEEKDAY(A2, 2)

Result: 3

Returns 3 for a Wednesday (Mon=1 system).

FAQ

How do I flag weekends?

Use =WEEKDAY(A2,2)>5 — TRUE for Saturday and Sunday.

Related functions

TODAY NETWORKDAYS EOMONTH