See Also Example
Returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week for a date argument.
The dateexpression part of the syntax is any numeric expression Numbers to the left of the decimal point in dateexpression represent the date; numbers to the right represent the time. Negative numbers represent dates prior to December 30, 1899. or string expression that can represent a date and/or time from January 1, 100 through December 31, 9999, where January 1, 1900 is 2.
If dateexpression is Null, this function returns a Null.
Date, Date$ Functions
Date, Date$ Statements
Weekday Function Example
The example uses Weekday to determine the day of the week. To try this example, paste the code into the Declarations section of a form. Then press F5 and click the form.
Sub Form_Click ()
Dim DayNum, Msg ' Declare variables.
DayNum = Weekday(Now) ' Get current day of the week.
If DayNum = 1 Or DayNum = 7 Then ' See if it's a weekend day
Msg = "Today is a weekend day."
Else ' or a weekday.
Msg = "Today is a weekday."
MsgBox Msg ' Display message.