Weekday Function

Returns a whole number representing the day of the week.

Syntax

Weekday(date, [firstdayofweek])

Arguments

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

Settings

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

Remarks

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.

Requirements

Version 1

See Also

Date Function
Day Function
Month Function
Now Function
Year Function