Sub DayOfWeek($date As DateTime) As Integer


Returns the day of the week for the specified date as an integer between 1 and 7, where Sunday is the first day of the week and Saturday is the seventh day.


DayOfWeek is not compliant with the ISO 8601 standard, which defines Monday as the first day of the week.


Parameters


  • $date ... Date expression.


Example:

Dim $i

$i = DayOfWeek(Now)
' returns eg. i = 4 (=Wednesday)