Export (0) Print
Expand All

Weekday Function

Returns a whole number representing the day of the week.


                      Weekday(date, [firstdayofweek])

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.

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

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

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.

Community Additions

Show:
© 2014 Microsoft