Skip to main content

Weekday

Returns a whole number representing the day of the week.

Synopsis

Weekday(weekday[,firstdayofweek])

Arguments

weekday Any expression that can represent a date.
firstdayofweek Optional — A constant that specifies the first day of the week. If omitted, vbSunday is assumed. See Description section for values.

Description

The Weekday function returns an integer between 1 and 7 (inclusive) specifying the day of the week represented by weekday. The first day of the week is, by default, Sunday, or the current NLS day of week setting overriding this default system-wide.

The firstdayofweek argument can be used to set the first day of the week for this statement to the day of your choosing. The firstdayofweek argument can have the following values:

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

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

Examples

The following example uses the Weekday function to obtain the default day of the week for the specified date:

MyDay0 = Weekday("11/1/2005")
Println MyDay0

Nov. 1, 2005 is a Tuesday, so Weekday("11/1/2005") returns 3.

The following example shows the effects of the firstdayofweek argument:

MyDay1 = Weekday("11/1/2005",vbSunday)
MyDay2 = Weekday("11/1/2005",vbMonday)
MyDay3 = Weekday("11/1/2005",vbTuesday)
MyDay4 = Weekday("11/1/2005",vbWednesday)
MyDay5 = Weekday("11/1/2005",vbThursday)
MyDay6 = Weekday("11/1/2005",vbFriday)
MyDay7 = Weekday("11/1/2005",vbSaturday)
Println "Day is: ",MyDay1," Week begins Sunday"
Println "Day is: ",MyDay2," Week begins Monday"
Println "Day is: ",MyDay3," Week begins Tuesday"
Println "Day is: ",MyDay4," Week begins Wednesday"
Println "Day is: ",MyDay5," Week begins Thursday"
Println "Day is: ",MyDay6," Week begins Friday"
Println "Day is: ",MyDay7," Week begins Saturday"

See Also

FeedbackOpens in a new tab