Weekday Function

Syntax

Weekday(dateexpr)

Group

Time/Date

Description

Return the weekday.

  • vbSunday (1) - Sunday
  • vbMonday (2) - Monday
  • vbTuesday (3) - Tuesday
  • vbWednesday (4) - Wednesday
  • vbThursday (5) - Thursday
  • vbFriday (6) - Friday
  • vbSaturday (7) - Saturday
Parameter Description
dateexpr Return the weekday for this date value. If this value is Null then Null is returned.

See Also: Date( ), Day( ), Month( ), WeekdayName( ), Year( ).

Example

Sub Main
Debug
.Print Weekday(#1/1/1900#) ' 2
Debug
.Print Weekday(#1/1/2000#) ' 7
End
Sub