Explanation

WEEKDAY function returns the number of the day in the week – from 1 to 7.

WEEKDAY Syntax

=WEEKDAY(serial_number, [return_type])

serial_number – The date for which we want to find the number of the day.

[return_type] – Indicates which day is considered the first day of the week. By default, if the argument is omitted, the first day of the week is Sunday. If we want the week to start on Monday, we can type “2” in this argument. 

These are the various options for the first day of the week:

Example

Practice WEEKDAY

Let’s practice the WEEKDAY function: