Weekday Function

Description

Returns a Variant (Integer) containing a whole number representing the day of the week.

Syntax

Weekday(date, [firstdayofweek])

The Weekday function syntax has these named arguments:

Part	Description

date	Required. Variant, numeric expression, string expression, or any combination, that can represent a date. If date contains Null, Null is returned.
firstdayofweek	Optional. A constant that specifies the first day of the week. If not specified, vbSunday is assumed.

Settings

The firstdayofweek argument has these settings:

Constant	Value		Description

vbUseSystem	0		Use the NLS API setting.
vbSunday	1		Sunday (default).
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.

See Also

Date function, Date statement, Day function, Month function, Now function, Year function.

Example

This example uses the Weekday function to obtain the day of the week from a specified date.

Dim MyDate, MyWeekDay
MyDate = #February 12, 1969#        ' Assign a date.
MyWeekDay = Weekday(MyDate)            ' MyWeekDay contains 4 because 
                                            ' MyDate represents a Wednesday.