WEEKDAY

Converts a date into an integer corresponding to a day of the week

WEEKDAY( Date , Return Type)

Returns an integer corresponding to the day of the week.

Arguments

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

Output

Day of the week in integer form.

Example

Last updated