WEEKDAY Function in Excel – Get the day of the week from date

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

WEEKDAY (serial_number, [return_type])

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

weekday function in Excel formula 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:

weekday function in Excel 1

Result:

weekday function in Excel 2

 

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:

weekday function in Excel 3

Result:

weekday function in Excel 4

 

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:

weekday function in Excel 5

Result:

weekday function in Excel 6

 

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

weekday function in Excel formula 2

previous-small WEEKDAY Function in Excel                                                                                                                next_small WEEKDAY Function in Excel