WEEKDAY (weekday)

<< Click to Display Table of Contents >>

WEEKDAY (weekday)

Syntax:

WEEKDAY(Date [, Mode])

Description:

Returns the day of the week of a date as a number (from 1 to 7 or from 0 to 6).

Mode (optional) lets you change the type of values to be returned:

1 or omitted: Numbers from 1 (Sunday) to 7 (Saturday) are returned.

2: Numbers from 1 (Monday) to 7 (Sunday) are returned.

3: Numbers from 0 (Monday) to 6 (Sunday) are returned.

Example:

WEEKDAY("09/25/1966") returns 1 (i.e., Sunday)

WEEKDAY("09/25/1966", 2) returns 7 (i.e., Sunday)

See also:

ISOWEEKNUM, ISOWEEK, WEEKNUM, YEAR, MONTH, DAY