Author: Oscar Cronquist Article last updated on June 20, 2018

Converts a date to a weekday number from 1 to 7.

Formula in cell D3:

=WEEKDAY(B3)

Excel Function Syntax

WEEKDAY(serial_number,[return_type])

Arguments

serial_number Required. The Excel date value you want to extract the WEEKDAY number from.
return_type Optional. Determines the type of return value, see table below.

 

Return_type Number returned
1 or omitted Numbers 1 to 7 for Sunday to Saturday.
2 Numbers 1 to 7 for Monday to Sunday.
3 Numbers 0 to 6 for Monday to Sunday.
11 Numbers 1 to 7 for Monday to Sunday.
12 Numbers 1 to 7 for Tuesday to Monday.
13 Numbers 1 to 7 for Wednesday to Tuesday.
14 Numbers 1 to 7 for Thursday to Wednesday.
15 Numbers 1 to 7 for Friday to Thursday .
16 Numbers 1 to 7 for Saturday to Friday .
17 Numbers 1 to 7 for Sunday to Saturday.