Weekday Function

Syntax:

Weekday(dateexpr)

Group:

Time/Date

Description:

Return the weekday.

 

Parameter

Description

dateexpr

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

 

 

firstday

Value

Description (Return value)

vbSunday

1

Sunday

vbMonday

2  

Monday

vbTuesday

3

Tuesday

vbWednesday

4

Wednesday

vbThursday

5

Thursday

vbFriday

6

Friday

vbSaturday

7

Saturday

 

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