WeekdayName Function

 

Returns a string indicating the specified day of the week.

Syntax

WeekdayName(weekday, abbreviate, firstdayofweek)

Arguments

  • 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.

Settings

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

Remarks

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

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

Requirements

Version 2

See Also

MonthName Function