Data Type: Long
The ordinal number of the required weekday, from 1 to 7.
Data Type: Boolean
Specifies whether to return the full day name or an abbreviation.
Data Type: Integer
Specifies which day of the week should be first.
Returns the real name of the day.
WeekDayNo must be a number
between 1 and 7, or the function generates runtime error 5,
“Invalid procedure call or argument.”
FirstDayOfWeek is omitted,
WeekdayName treats Sunday
as the first day of the week.
The default value of
You’d expect that, given a date, WeekDayName would return the name of that date’s day. But this isn’t how the function works. To determine the name of the day of a particular date, combine WeekDayName with a call to the WeekDay function, as the following code fragment shows:
sDay = WeekDayName(Weekday(dDate, iFirstDay), _ bFullName, iFirstDay)
Note that the value of the
FirstDayOfWeek argument must be the
same in the calls to both functions for
WeekDayName to return an accurate