WeekdayName

Returns a string indicating the specified day of the week.

Structure

WeekdayName(weekday, abbreviate, firstdayofweek)

Parameters

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.

Parameter 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

Example

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

Dim MyDate

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