Description
Returns a whole number representing the day of the week.
Syntax
Weekday(date)
The date named argument is limited to numbers or strings, in any combination, that can represent a date. If date contains no valid data, Null is returned.
Return Values
Value |
Description |
1 |
Sunday |
2 |
Monday |
3 |
Tuesday |
4 |
Wednesday |
5 |
Thursday |
6 |
Friday |
7 |
Saturday |
See Also
Date Function, Date Statement, Day Function, Month Function, Now Function, Year Function.
Example
This example uses the Weekday function to obtain the day of the week from a specified date.
MyDate = #February 12, 1969# ' Assign a date. MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 4 since it ' was a Wednesday.