Polar Studio

Weekday

Public Function Weekday(ByVal InputDate As Date, Optional ByVal FirstDayOfWeek As Long = 0) As Long

Returns the number of the day in the week for a specified date (1-7).

InputDate: The date to get the weekday for.
FirstDayOfWeek: The first day of week. Use one of: 0:vbUseSystemDayOfWeek (Effectively Sunday), 1:vbSunday, 2:vbMonday, 3:vbTuesday, 4:vbWednesday, 5:vbThursday, 6:vbFriday, 7:vbSaturday

SendDebug $"Today is {({"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"})(Weekday(Date) - 1)}" 'Prints the name of today. '-1' because arrays are zero-based, while weekday is 1-based

See also: