Visual Basic Language Reference  

Weekday Function

Returns an Integer value containing a number representing the day of the week.

Public Function Weekday( _
   ByVal DateValue As DateTime, _
   Optional ByVal DayOfWeek As FirstDayOfWeek = FirstDayOfWeek.Sunday _
) As Integer

Parameters

DateValue
Required. Date value for which you want to determine the day of the week.
DayOfWeek
Optional. A value chosen from the FirstDayOfWeek enumeration that specifies the first day of the week. If not specified, FirstDayOfWeek.Sunday is used.

Settings

The DayOfWeek argument can have one of the following settings.

Enumeration value Value Description
FirstDayOfWeek.System 0 First day of week specified in system settings
FirstDayOfWeek.Sunday 1 Sunday (default)
FirstDayOfWeek.Monday 2 Monday (complies with ISO standard 8601, section 3.17)
FirstDayOfWeek.Tuesday 3 Tuesday
FirstDayOfWeek.Wednesday 4 Wednesday
FirstDayOfWeek.Thursday 5 Thursday
FirstDayOfWeek.Friday 6 Friday
FirstDayOfWeek.Saturday 7 Saturday

Exceptions/Errors

Exception type Error number Condition
ArgumentException 5 DayOfWeek is less than 0 or more than 7.

Remarks

The value returned by the Weekday function corresponds to the values of the FirstDayOfWeek enumeration; that is, 1 indicates Sunday and 7 indicates Saturday.

If DayOfWeek is less than 0 or more than 7, an ArgumentException error occurs.

Note   Weekday uses the current calendar setting from the CurrentCulture property of the CultureInfo class in the System.Globalization namespace. The default CurrentCulture values are determined by Control Panel settings.

Example

This example uses the Weekday function to obtain the day of the week from a specified date.

Dim MyDate As Date
Dim MyWeekDay As Integer
MyDate = #2/12/1969#   ' Assign a date.
MyWeekDay = Weekday(MyDate)   ' MyWeekDay contains 4 because 
   ' MyDate represents a Wednesday.

See Also

Day Function | Month Function | Now Property | WeekdayName Function | Year Function | DatePart Function | System Namespace | DateTime Structure | ArgumentException