WEEKDAY


Returns the day of the week for a given date.

Syntax:

WEEKDAY(date, type)
returns the day of the week that date falls on, as a number.

The number returned depends on type, as follows:




day of the week
type=1
type=2
type=3
Sunday
1
7
6
Monday
2
1
0
Tuesday
3
2
1
Wednesday
4
3
2
Thursday
5
4
3
Friday
6
5
4
Saturday
7
6
5


If type is omitted, it is assumed to be 1.

Example:

WEEKDAY("2021-12-18", 1)
returns 7. 18 Dec 2021 falls on a Saturday.






 
Created with Zapof