VB & VBA in a Nutshell: The Language

Weekday Function

Named Arguments

Yes

Syntax

Weekday(date, [firstdayofweek])

date

Use: Required

Data Type: Variant

Any valid date expression.

firstdayofweek

Use: Optional

Data Type: Integer

Constant value specifying the first day of the week.

Return Value

A Variant of subtype Integer.

Description

Determines the day of the week of a given date.

Rules at a Glance

• The following intrinsic constants determine the value returned by the Weekday function:

  Constant	Return Value	Day Represented
  vbSunday	1	Sunday
  vbMonday	2	Monday
  vbTuesday	3	Tuesday
  vbWednesday	4	Wednesday
  vbThursday	5	Thursday
  vbFriday	6	Friday
  vbSaturday	7	Saturday

• If date is Null, the Weekday function also returns Null.

• The following table describes the possible settings for the firstdayofweek argument:

  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

Programming Tips and Gotchas

• If you specify a firstdayofweek argument, the function returns the day of the week relative to firstdayofweek. For instance, if you set the value of firstdayofweek to vbMonday (2), indicating that Monday is the first day of the week, and attempt to determine the day of the week on which October 1, 1996, falls, the function returns a 2. That's because October 1, 1996, is a Tuesday, the second day of a week whose first day is Monday.

• The fact that the function's return ...