Related Function:

The WEEKDAY function returns an integer between 0 and 7 representing the day of the week for a supplied date.

Syntax

=WEEKDAY(serial_number,[return_type])

Arguments

Argument Description
serial_number A sequential number that represents the date of the day you are trying to find
[return_type] Optional. A number that determines the type of return value

[return_type] Weekday numbering
1 (default) Sunday = 1, Monday = 2, … , Saturday = 7
2 Monday = 1, Tuesday = 2, … , Sunday = 7
3 Monday = 0, Tuesday = 1, … , Sunday = 6
11 Monday = 1, Tuesday = 2, … , Sunday = 7
12 Tuesday = 1, Wednesday = 2, … , Monday = 7
13 Wednesday = 1, Thursday = 2, … , Tuesday = 7
14 Thursday = 1, Friday = 2, … , Wednesday = 7
15 Friday = 1, Saturday = 2, … , Thursday = 7
16 Saturday = 1, Sunday = 2, … , Friday = 7
17 Sunday = 1, Monday = 2, … , Saturday = 7

Note: The serial_number argument for the WEEKDAY function should be input as either:

  • A reference to a cell containing a date or,
  • A date returned from another function or formula

Examples

  A B C
1 Data    
2 Mon 29-Jun-2015    
3      
4 Formula Result Notes
5 =WEEKDAY(A2) 2 Day of the week, with numbers 1 (Sunday) through 7 (Saturday)
6 =WEEKDAY(A2,2) 1 Day of the week, with numbers 1 (Monday) through 7 (Sunday)
7 =WEEKDAY(A2,3) 0 Day of the week, with numbers 0 (Monday) through 6 (Sunday)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied serial_number or the supplied [return_type] cannot be recognized as a numeric value
#NUM! Occurs if the supplied serial_number argument is numeric but is out of range for the current date base, or the supplied [return_type] argument is not one of the permitted values (1-3 or 11-17)