WeekdayName Function

Returns a string indicating the specified day of the week.

WeekdayName(weekday, abbreviate, firstdayofweek)

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.

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

The following example uses the WeekDayName function to return the specified day:

Dim MyDate
MyDate = WeekDayName(6, True)   ' MyDate contains Fri.