WEEKDAY

This function returns the number corresponding to the day of the week for a specified date.

Syntax

WEEKDAY(date, [type])

This function has these arguments:

Argument	Description
date	[Required] Date for which you want to determine the day of the week provided
type	[Optional] Number that represents the numbering scheme for the returned weekday value; can be any of:
	Value	Number returned
	1 or omitted	Numbers 1 (Sunday) through 7 (Saturday)
	2	Numbers 1 (Monday) through 7 (Sunday)
	3	Numbers 0 (Monday) through 6 (Sunday)

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

The returned day of the week is given as an integer, ranging from 0 to 6 or 1 to 7, depending on the setting of the type argument.

WEEKDAY(A2)

WEEKDAY(R2C1)

WEEKDAY(36828) gives the result 1 equivalent to Sunday