Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Weekday Function
Collapse the table of content
Expand the table of content

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.

Requirements

Show:
© 2015 Microsoft