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.