WEEKDAY
Converts a date into an integer corresponding to a day of the week
Last updated
Converts a date into an integer corresponding to a day of the week
Last updated
WEEKDAY( Date , Return Type)
Returns an integer corresponding to the day of the week.
Argument
Description
Date
Date/time value(s)
Return Type
Determines calendar week output.
1: 1 (Sunday) - 7 (Saturday)
2: 1 (Monday) - 7 (Sunday)
3: 1 (Tuesday) - 7 (Monday)
4: 1 (Wednesday) - 7 (Tuesday)
5: 1 (Thursday) - 7 (Wednesday)
6: 1 (Friday) - 7 (Thursday)
7: 1 (Saturday) - 7 (Friday))
Day of the week in integer form.