Returns a number representing the day of the week of the date provided.
SYNTAX: =WEEKDAY(date, [type])
date - The date for which to determine the day of the week. Must be a reference to a cell containing a date, a function returning a date type or a number.
type - [optional] - A number indicating which numbering system to use to represent weekdays. By default, counts starting from Sunday = 1.
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice.