WeekDay

Calculates the weekday value of the given date argument passed to the function. Date values in VBA are evaluated using the Gregorian Calendar.

Syntax

WeekDay(Date)

Date:

A string or expression that can represent a date value. This includes any combination of date literals, numbers that look like dates, strings that look like dates, and dates from functions.

Return Value

Returns an integer between the range of 1-7 inclusive representing the whole number for the weekday:

Related Functions

Date | Year| Month | Day

Example

Dim varMyBDate, varMyWeekDay
varMyBDate = #8/07/1958#
varMyWeekDay = WeekDay(varMyBDate)
' returns 3 (Tuesday)