WeekdayName Function [VBA]
The WeekdayName function returns the weekday name of a specified day of the week.
WeekdayName(Weekday as Integer [,Abbreviate as Boolean [,FirstDayofWeek as Integer]])
String
Weekday: Value from 1 to 7, MonÂday to SunÂday, whose Week Day Name need to be calculated.
Abbreviate: Optional. A Boolean value that indicates if the weekday name is to be abbreviated.
FirstDayofWeek: Optional. Specifies the first day of the week.
First day of Week:
Named constant |
Value |
Description |
vbUseSystemDayOfWeek |
0 |
Use National Language Support (NLS) API setting |
vbSunÂday |
1 |
SunÂday (default) |
vbMonday |
2 |
Monday |
vbTuesday |
3 |
Tuesday |
vbWednesday |
4 |
Wednesday |
vbThursday |
5 |
Thursday |
vbFriday |
6 |
Friday |
vbSaturday |
7 |
Saturday |
None
REM ***** BASIC *****
Option VBASupport 1
Sub Example_WeekdayName
Dim tgf as Integer
tgf = 6
print tdf &" "& WeekdayName(tgf,False,vbSunday)
End Sub