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.
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")