Returns a string indicating the specified day of the week.
WeekdayName(weekday, abbreviate, firstdayofweek)
Arguments
- weekday
- Required. The numeric designation for the day of the week. Numeric value of each day depends on setting of the firstdayofweek setting.
- abbreviate
- Optional. Boolean value that indicates if the weekday name is to be abbreviated. If omitted, the default is False, which means that the weekday name is not abbreviated.
- firstdayofweek
- Optional. Numeric value indicating the first day of the week. See Settings section for values.
Settings
The firstdayofweek argument can have the following values:
| Constant |
Value |
Description |
| vbUseSystemDayOfWeek |
0 |
Use National Language Support (NLS) API setting. |
| vbSunday |
1 |
Sunday (default) |
| vbMonday |
2 |
Monday |
| vbTuesday |
3 |
Tuesday |
| vbWednesday |
4 |
Wednesday |
| vbThursday |
5 |
Thursday |
| vbFriday |
6 |
Friday |
| vbSaturday |
7 |
Saturday |
Remarks
The following example uses the WeekDayName function to return the specified day:
Dim MyDate
MyDate = WeekDayName(6, True) ' MyDate contains Fri.
Requirements
Version 2
See Also
MonthName Function
Producten en Diensten
Technische docs, tools
Overzicht
