WEEKDAY
From AgileApps Support Wiki
The WEEKDAY function evaluates a date and returns the day of the week.
- Syntax
WEEKDAY('dString' [, return_type])
Day, month, and year are required; hour and minute are optional.
The return_type parameter specifies the day that the week starts:
- 0 or 1: Week starts on Sunday (Sunday is day one) (default)
- 2: Week starts on Monday (Monday is day one)
- Return
- Number
- Range 1-7
- Example, where 08/10/2009 is a Monday
WEEKDAY('08/10/2009', 0) = 2
WEEKDAY('08/10/2009', 1) = 2
WEEKDAY('08/10/2009') = 2