Returns a whole number representing the day of the week.
Weekday(date, [firstdayofweek])
The Weekday function syntax has these named arguments:
|
Part |
Description |
|
date |
Numeric or string expression, in any combination, that can represent a date. If date contains Null, Null is returned. |
|
firstdayofweek |
A constant that specifies the first day of the week, as described in Settings. If omitted, vbSunday is assumed. |
The firstdayofweek argument has these settings:
|
Constant |
Value |
Description |
|
vbUseSystem |
0 |
Use NLS API setting. |
|
vbSunday |
1 |
Sunday |
|
vbMonday |
2 |
Monday |
|
vbTuesday |
3 |
Tuesday |
|
vbWednesday |
4 |
Wednesday |
|
vbThursday |
5 |
Thursday |
|
vbFriday |
6 |
Friday |
|
vbSaturday |
7 |
Saturday |
The Weekday function can return any of these values:
|
Constant |
Value |
Description |
|
vbSunday |
1 |
Sunday |
|
vbMonday |
2 |
Monday |
|
vbTuesday |
3 |
Tuesday |
|
vbWednesday |
4 |
Wednesday |
|
vbThursday |
5 |
Thursday |
|
vbFriday |
6 |
Friday |
|
vbSaturday |
7 |
Saturday |
Date Function, Date Statement, Day Function, Month Function, Now Function, Year Function.
This example uses the Weekday function to obtain the day of the week from a specified date.
MyDate = #February 12, 1969# ' Assign a date.= Weekday(MyDate) ' MyWeekDay contains 4 because
' MyDate represents a Wednesday.