WEEKDAY function

WEEKDAY returns the day of the week for the given date value. The day is returned as an integer between 1 and 7. The day of the week on which numbering begins depends on the type.

Syntax

WEEKDAY(number,type)

  • number, as a date value, is a decimal for which the weekday is returned as an integer.
  • type (optional) determines the type of calculation. For type = 1, the weekdays are counted starting from Sunday, which is the default value even when the type argument is missing.
Table 1. Weekdays returned according to type argument
Type Integer returned (weekday)
1 or missing (default) 1 (Sunday) through 7 (Saturday)
2 1 (Monday) through 7 (Sunday)
3 0 (Monday) through 6 (Sunday)
11 1 (Monday) through 7 (Sunday)
12 1 (Tuesday) through 7 (Monday)
13 1 (Wednesday) through 7 (Tuesday)
14 1 (Thursday) through 7 (Wednesday)
15 1 (Friday) through 7 (Thursday)
16 1 (Saturday) through 7 (Friday)
17 1 (Sunday) through 7 (Saturday)

Example

WEEKDAY("6/14/2000") returns 4. The type argument is missing; therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000, was a Wednesday and, therefore, day number 4.

WEEKDAY("7/24/1996",1) returns 4. The type argument is 1; therefore Sunday is day number 1. July 24, 1996, was a Wednesday and, therefore, day number 4.

WEEKDAY("7/24/1996",2) returns 3. The type argument is 2; therefore Monday is day number 1. July 24, 1996, was a Wednesday and, therefore, day number 3.

WEEKDAY(NOW()) returns the number of the current day.

To obtain a function indicating whether a day in cell A1 is a business day, use the IF and WEEKDAY functions as follows: IF(WEEKDAY(A1,2)<6,"business day","weekend")