WEEKDAY

From AgileApps Support Wiki
Revision as of 21:54, 27 August 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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