WEEKDAY - Returning the Day of the Week

Parameter

Serial_number

Represents the date entered.

Despite the text and date types, the Serial_number parameter can also be of the serial number type of the1900 date system for extracted data. For example, 35796 represents 1998-01-01.

The Serial_number parameter can only be of the date or text type for real-time data.

WEEKDAY("2005/9/10")

6

(Saturday) 

Note:

The format 2005/9/10 is not supported for real-time data. You need to change the   format to 2005-09-10.

WEEKDAY("2005/9/11")

0

(Sunday) 

Note:

The format 2005/9/11 is not supported for real-time data. You need to change the   format to 2005-09-10.

WEEKDAY(35796)

4

(Thursday)

The format is not supported for real-time data.