WEEKDAY

Description

Returns the day of the week that corresponds to the supplied date. The optional parameter allows you to specify either Sunday or Monday as the first day of the week.

Syntax

WEEKDAY ( number, [return_type] )

Parameter	Description
number	A date represented as: A serial number (for example 40339, which represents the DATEVALUE) Text (for example, "06-21-11" or "5-Jun-13")
return_type	(Optional) The first day of the week. Possible values are: 1— (Default) indicates a result of 1 (Sunday) through 7 (Saturday). 2 — Indicates 1 (Monday) through 7 (Sunday). 3 — Indicates 0 (Monday) through 6 (Sunday).

Parameter

Description

number

A date represented as:

A serial number (for example 40339, which represents the DATEVALUE)
Text (for example, "06-21-11" or "5-Jun-13")

return_type

(Optional) The first day of the week. Possible values are:

1— (Default) indicates a result of 1 (Sunday) through 7 (Saturday).
2 — Indicates 1 (Monday) through 7 (Sunday).
3 — Indicates 0 (Monday) through 6 (Sunday).

Remarks

WEEKDAY returns a number ranging from 1 (Sunday) to 7 (Saturday).

Examples

This function returns 1, indicating Sunday:

WEEKDAY(41322)

This function returns 3, indicating Tuesday:

WEEKDAY("03/20/12", 1)