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)

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




Trademarks | IBM Connections wiki