DAYOFWEEK(theDate as Date)
Description
Returns an integer from 1=Sunday to 7=Saturday.
Example
Dim theDate as Date
Dim result as Integer
theDate=DateVal(1998,9,27)
result=DayOfWeek(theDate) 'will calculate result=1 because the date is a Sunday