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