Excel Function

WEEKDAY

Returns day-of-week number.

WEEKDAY(serial_number, [return_type])

Arguments

serial_number

Required

Enter a date/reference-related value.

return_type

Optional

Weekday numbering system: 1/omitted = Sunday 1 to Saturday 7, 2 = Monday 1 to Sunday 7, 3 = Monday 0 to Sunday 6, 11-17 = Monday-to-Sunday start variants.

Practice Preview

calculate and display date/time values. Use WEEKDAY to Returns day-of-week number. use 2 for return_type. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=WEEKDAY(B2, 2)

Practice This Function

Practice in Sequential Mode Back to Function List