WeekDayName
This function retrieves a string indicating the specified day of the week.
Syntax
WeekDayName(weekday, [abbreviate], [firstdayofweek])
Parameters
- weekday
- Required. A number from 1 through 7 that indicates a day of the week. The numeric value of each day depends on 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 that indicates the first day of the week. The following table shows the possible values for the firstdayofweek parameter. If omitted, the default is vbUseSystem.
Constant
|
Value
|
Description
|
| vbUseSystem |
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 |
Return Values
Returns a string that indicates the day of the week.
Remarks
If the weekday parameter is fractional, it is rounded to the nearest even integer before it is evaluated.