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:
Copy Code | |
---|---|
Dim MyDate MyDate = WeekDayName(6, True) ' MyDate contains Fri. |