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

Parameters

Parameters Description
dateexpr Return the weekday for this date value. If this value is Null then Null is returned.

Example

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

See also

Date( ), Day( ), Month( ), WeekdayName( ), Year( )