Returns the day of the week for a given date (1 = Sunday, 2 = Monday, etc.).

WEEKDAY(Date)

Date: date for which weekday should be determined.

WEEKDAY(DATE(1,1,2017)) will return the value 1 for Sunday