WEEKDAY
WEEKDAY(date)
The day of the week of a date, from 1 (Sunday) to 7 (Saturday), such as for finding tasks that start on a weekend. The numbering is always Excel's default, Sunday first: there is no second argument to start the week on Monday.
Arguments
| Argument | What to give it |
|---|---|
| date | A date, like [Start date]. Blank gives blank. |
Examples
Formula=WEEKDAY([Start date])
The day of the week the task starts on: 1 for Sunday through 7 for Saturday.
Formula=WEEKDAY([Start date]) = 1 OR WEEKDAY([Start date]) = 7
As a guardrail: tasks that start on a Saturday or a Sunday.
Formula=WEEKDAY([Finish date]) = 6
TRUE for tasks that finish on a Friday.