What is the syntax to return the weekday name from date?

WeekDayName(weekday, abbreviate, firstdayofweek)
‘weekday can be values 1-7; mandatory parameter
‘abbreviate can be true or false; optional parameter with false default
‘firstdayofweek can be values 1-7 for Sunday to Saturday; optional parameter
‘examples
MsgBox (WeekdayName(3)) 'returns Tuesday
MsgBox (WeekdayName(1, True)) 'returns Sun
MsgBox (WeekdayName(1, False)) 'returns Sunday
MsgBox (WeekdayName(7, False, 6)) 'returns Thursday

 

Advertisements