Weekday Function

Office VBScript

Microsoft® Visual Basic® Scripting Edition Weekday Function  Language Reference 
Version 1 


Description
Returns a whole number representing the day of the week.
Syntax
Weekday(date, [firstdayofweek])

The Weekday function syntax has these arguments:

Part Description
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
vbUseSystem 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 Values
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.