How is the usage of the weekday function in VB?

In VB, the Weekday function is used to retrieve the day of the week for a specified date. Its usage is as follows:

Get the day of the week from a specified date.

In this case, the “date” variable is used to obtain the day of the week, and it can be either a date value or a string representing the date. The “firstdayofweek” is an optional parameter used to specify which day of the week is considered the first day.

The Weekday function returns an integer value representing the day of the week for the specified date. The return value ranges from 1 to 7, where 1 represents Sunday, 2 represents Monday, and so on, with 7 representing Saturday.

Here are a few examples:

Example 1: Get the day of the week for today’s date
Dim today As Date
today = Date.Today
Dim weekday As Integer
weekday = Weekday(today)
MsgBox(“Today is ” & weekday & “th day of the week”)

Example 2: Retrieve the day of the week for a specified date
Dim dateStr As String
dateStr = “2022/01/01”
Dim dateValue As Date
dateValue = Date.Parse(dateStr)
Dim dayOfWeek As Integer
dayOfWeek = Weekday(dateValue)
MsgBox(dateStr & ” is on a ” & dayOfWeek)

Example 3: Specify Monday as the first day of the week.
Dim dateStr As String
dateStr = “2022/01/01”
Dim dateValue As Date
dateValue = Date.Parse(dateStr)
Dim weekday As Integer
weekday = Weekday(dateValue, vbMonday)
MsgBox(dateStr & ” is on ” & weekday)

Note: In VB, the starting value of the week is determined by the system’s regional settings. If the parameter firstdayofweek is not specified, the week will be calculated based on the system settings by default.