WEEKDAY function returns the number of the day in the week – from 1 to 7.
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:
Let’s practice the WEEKDAY function: