WEEKDAY Function in Excel takes the date as input and returns the day of the week. Day of the week will be between 1 and 7. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday.
Syntax for WEEKDAY Function in Excel
serial_number – The date for which you want to get the day of week.
return_type – [optional] A number 1-3 representing which day should be considered first. Default is 1
Example of WEEKDAY Function in Excel
WEEKDAY Function with default return_type or return_type =1
When Return type =1, first day of the week will be Sunday and Sunday is considered as 1 and value is incremented till Saturday, which is 7
Formula:
Result:
WEEKDAY Function with return_type =2
When Return type =2, first day of the week will be Monday and Monday is considered as 1 and value is incremented till Sunday, which is 7
Formula:
Result:
WEEKDAY Function with return_type =3
When Return type =3, first day of the week will be Monday and Monday is considered as 0 and value is incremented till Sunday, which is 6
Formula:
Result:
More on Return_Type:
What If we want to start a week with Tuesday?
Refer the below table with different value for return_type that defines, which day is the start day of the week