WEEKDAY
Category: DateTime Function.
Description: Returns an integer representing the day of the week for a specified date.
Syntax: WEEKDAY(date_serial_number,[return_type])
Date_serial_number is a serial number representing a date.
Use functions such as DATE to supply an argument to the function.
Return_type is a number that specifies which integers are to be assigned to each weekday.
Return_type
|
Number returned
|
1 or omitted
|
Numbers 1 (Sunday) through 7 (Saturday)
|
2
|
Numbers 1 (Monday) through 7 (Sunday)
|
3
|
Numbers 0 (Monday) through 6 (Sunday)
|
11
|
Numbers 1 (Monday) through 7 (Sunday)
|
12
|
Numbers 1 (Tuesday) through 7 (Monday)
|
13
|
Numbers 1 (Wednesday) through 7 (Tuesday)
|
14
|
Numbers 1 (Thursday) through 7 (Wednesday)
|
15
|
Numbers 1 (Friday) through 7 (Thursday)
|
16
|
Numbers 1 (Saturday through 7 (Friday)
|
17
|
Numbers 1 (Sunday) through 7 (Saturday)
|