|weekday||An integer 1 through 7, inclusive, designating the day of the week. The numeric value of each day depends on the firstdayofweek setting.|
|abbreviate||Optional — Boolean value that indicates if the weekday name is to be returned fully spelled out, or abbreviated. If omitted, the default is False, which means that the weekday name is returned fully spelled out.|
|firstdayofweek||Optional — Numeric value indicating the first day of the week. See Description section for values.|
The WeekdayName function returns a day name corresponding to the day of the week represented by weekday. The first day of the week is, by default, Sunday, or the current NLS day of week setting overriding this default system-wide.
The firstdayofweek argument can be used to set the first day of the week for this statement to the day of your choosing. The firstdayofweek argument can have the following values:
|vbUseSystem||0||Use National Language Support (NLS) API setting.|
The following example uses the WeekDay and WeekDayName functions to return the name of the day of the week for the specified date:
Dim WDayNum,WDayName WDayNum = Weekday("11/1/2005") Println WDayNum WDayName = WeekdayName(3) Println WDayName
November 1, 2005 is a Tuesday.