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

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