WeekDay

The WeekDay function returns the day of the week of the specified date as a long.

Syntax
WeekDay(Date [, FirstDayOfWeek])
Return value
Type	Description
Long	Weekday
Parameter
Use	Name	Type	Passing	Description
Required	Date	Double	ByVal	The date to be evaluated
Optional	FirstDayOfWeek	Variant	ByVal	Determines the first day of the week.

You can use the optional FirstDayOfWeek parameter to define the first day of the week.

You can look up the calculated day of the week in the following table: