DAYNAME

Syntax:

DAYNAME(value:(Number|Date) {, mode:Number})

Returns a text string of the day given by value.

value must be either a number or date value.

If value is a number, usually number 1 represents Sunday, 2 being Monday through 7 being Saturday. Numbers outside the range [1,7] are reduced into this range, and an optional mode value may be used to adjust the calculation.

mode
1Sunday is day one
2Monday is day one
3Monday is day zero
11Monday is day one
12Tuesday is day one
13Wednesday is day one
14Thursday is day one
15Friday is day one
16Saturday is day one
17Sunday is day one
21Monday is day one (ISO 8601)
150Monday is day one (ISO 8601)

Revisions:

The optional mode parameter was added in 2.24.

Examples:

DAYNAME(7)

returns the text string "Saturday"

DAYNAME(1, 21)

returns the text string "Monday"

DAYNAME(TODAY)

returns today's day name as a text string.

See also WEEKDAY.