WEEKDAY( )
Returns the day of the week for a specified date value.
Syntax
WEEKDAY(date, option)
Arguments
date
The date or date expression from which you want to get the day of the week.
option
A number that represents the weekday format to return. Use one of the following values:
1 to get the day as a number from 1 (Sunday) to 7 (Saturday).
2 to get the day as a number from 1 (Monday) to 7 (Sunday).
3 to get the day as a number from 0 (Monday) to 6 (Sunday).
4 to get the full weekday name, for example, Wednesday. The result is locale‑specific.
5 to get the abbreviated weekday name, for example Wed. The result is locale‑specific.
If you omit option, WEEKDAY( ) assumes option 1.
Returns
The day of the week for a specified date value.
Example
The following example gets the full weekday name for each date value in the DateSold field:
WEEKDAY([DateSold], 4)