DayOfWeek
Returns the day of the week (from 1 for Monday to 7 for Sunday) for the date entered as a parameter.
Syntax
DayOfWeek(date)
date = date for which you want to retrieve the day of the week
Remarks
The returned value is ISO 8601-compliant.
If you want to retrieve the current day of the week, you can use the Now function as a parameter.
To retrieve the week number, use WeekNumber.
For the day of the year, use DayOfYear.
Example
DayOfWeek(Now()) = current day, so for Tuesday, December 1, 2009, it will return a 2 for Tuesday