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.
Version 1
Reference