Returns a Variant (Integer) containing a whole number representing the day of the week.
Syntax
Weekday(date, [firstdayofweek])
The Weekday function syntax has these named arguments:
| Part | Description |
|---|---|
| date | Required. Variant, numeric expression, string expression, or any combination, that can represent a date. If date contains Null, Null is returned. |
| Firstdayofweek | Optional. Specifies the first day of the week. If not specified, Sunday is assumed. |
Settings
The firstdayofweek argument has these settings:
| Value | Description |
|---|---|
| 0 | Use the NLS API setting. |
| 1 | Sunday (default) |
| 2 | Monday |
| 3 | Tuesday |
| 4 | Wednesday |
| 5 | Thursday |
| 6 | Friday |
| 7 | Saturday |
Return Values
The Weekday function can return any of these values:
| Value | Description |
|---|---|
| 1 | Sunday |
| 2 | Monday |
| 3 | Tuesday |
| 4 | Wednesday |
| 5 | Thursday |
| 6 | Friday |
| 7 | Saturday |