This documentation is archived and is not being maintained.
Weekday Function
Returns a whole number representing the day of the week.
Weekday(date, [firstdayofweek])
-
date
-
Any expression that can represent a date. If date contains Null, Null is returned.
-
firstdayofweek
-
A constant that specifies the first day of the week. If omitted, vbSunday is assumed.
The firstdayofweek argument has these settings:
|
Constant
|
Value
|
Description
|
|
vbUseSystemDayOfWeek
|
0
|
Use National Language Support (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
|
The following example uses the Weekday function to obtain the day of the week from a specified date:
Dim MyDate, MyWeekDay
MyDate = #October 19, 1962# ' Assign a date.
MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 6 because MyDate represents a Friday.