WEEKDAY

Use the WEEKDAY function to return the day of the week for a given date. The day is a number ranging from 1 (Sunday) to 7 (Saturday).

Use

WEEKDAY( date [, timezone] )
Returns the day of the week of a date or date/time ranging from 1 (Sunday) to 7 (Saturday).

Parameter	Required	Description
date	Yes	date of the day to return
timezone	No	the dates timezone or locale default if omitted

Returns

Number

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.