Weekday Function

Syntax:

Weekday(dateexpr)

Group:

Time/Date

Description: Return the weekday.

Parameters:

Parameter

Description

dateexpr

Returns 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

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( )