Weekday

Returns a whole number representing the day of the week.

Structure

Weekday(date, [firstdayofweek])

Parameters

date - Any expression that can represent a date. If date contains Null, Null is returned.

firstdayofweek - A constant that specifies the first day of the week. If omitted, vbSunday is assumed.

Parameter Values

The firstdayofweek argument has these settings:

Constant Value Description

vbUseSystemDayOfWeek 0 Use National Language Support (NLS) API setting.

vbSunday 1 Sunday

vbMonday 2 Monday

vbTuesday 3 Tuesday

vbWednesday 4 Wednesday

vbThursday 5 Thursday

vbFriday 6 Friday

vbSaturday 7 Saturday

Return Value

The Weekday function can return any of these values:

Constant Value Description

vbSunday 1 Sunday

vbMonday 2 Monday

vbTuesday 3 Tuesday

vbWednesday 4 Wednesday

vbThursday 5 Thursday

vbFriday 6 Friday

vbSaturday 7 Saturday

Example

The following example uses the Weekday function to obtain the day of the week from a specified date:

Dim MyDate, MyWeekDay

MyDate = #October 19, 1962# ' Assign a date.

MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 6 because MyDate represents a Friday. |