WEEKDAYNAME

WEEKDAYNAME(weekday [,abbreviate] [,firstdayofweek])

Returns the day of the week as a string (String).

weekday	The numeric designation for the day of the week (Integer).
abbreviate	(Optional) Whether the week day name is abbrevated (Boolean): False = the week day name is not abbreviated (default) True = the week day name is abbreviated
firstdayofweek	(Optional) A vbDayOfWeek constant that specifies the first day of the week (Integer): 0 = vbUseSystemDayOfWeek (default) 1 = vbSunday 2 = vbMonday 3 = vbTuesday 4 = vbWednesday 5 = vbThursday 6 = vbFriday 7 = vbSaturday

REMARKS

* If "abbreviate" = True then the weekday name will be abbreviated to three characters.
* If "abbreviate" = False then the weekday name will not be abbreviated.
* If "abbreviate" is left blank, then False is used.
* If "firstdayofweek" is left blank, then 0 is used.
* If "firstdayofweek" = vbUseSystemDayOfWeek, this takes the setting from the Control Panel, Region.
* Sunday is considered the first day of the week in: USA, Canada, South Africa, India, Japan, South Korea.
* Monday is considered the first day of the week in: UK, Germany, France, Australia, New Zealand, China.
* Numeric value of each day depends on setting of the firstdayofweek setting.
* You can use the MONTHNAME function to return the day of the month as a string.
* You can use the WEEKDAY function to return the number representing the day of the week for a given date.
* The equivalent .NET function is [[Microsoft.VisualBasic.DateAndTime.WeekdayName]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print WeekdayName(1)                                      'Monday  
Debug.Print WeekdayName(1, False)                               'Monday  
Debug.Print WeekdayName(1, True)                                'Mon  
Debug.Print WeekdayName(1, , vbDayOfWeek.vbUseSystemDayOfWeek)  'Monday  
Debug.Print WeekdayName(1, , vbDayOfWeek.vbMonday)              'Monday  
Debug.Print WeekdayName(1, , vbDayOfWeek.vbSunday)              'Sunday  
Debug.Print WeekdayName(2)                                      'Tuesday  
Debug.Print WeekdayName(2, True)                                'Tue  
Debug.Print WeekdayName(2, True, vbDayOfWeek.vbMonday)          'Tue  
Debug.Print WeekdayName(2, True, vbDayOfWeek.vbTuesday)         'Wed  
Debug.Print WeekdayName(2, True, vbDayOfWeek.vbWednesday)       'Thu  
Debug.Print WeekdayName(1, , vbDayOfWeek.vbUseSystemDayOfWeek)  'Monday