Excel WEEKDAY() Function

The WEEKDAY () function in excel returns number from 1 (Sunday) to 7 (Saturday) identifying the day of the week based on its date. This function Default return is - Sunday would be 1, Monday 2...so on till Saturday which will be 7.

Note: At times, you may have to change the format of the cell to numeric to get the date in numeric format.


WEEKDAY (serial_num, [return_type])


serial_num (required)- This parameter represents the date from which you want to extract the year part.

return_type(optional)- This parameter represents the day from which the week begins. The default value is 1.


Date & Time


This function returns a number between 1 and 7, depending upon the day of the week.

Example 1

Objective: Identify today's weekday number basis different return_type value

Col A Result Formula
11/15/2019 6  =WEEKDAY(A20)
11/15/2019 5  =WEEKDAY(A21,2)
11/15/2019 4  =WEEKDAY(A22,3)
11/15/2019 2  =WEEKDAY(A23,14)

Example 2

Objective: Return the weekday of the date given in 'Date Input'

Col A Result Formula
21-Jan-19 4 =WEEKNUM(E47,2)
21-Sep-19 38 =WEEKNUM(E48,2)

Example 3

Objective: Calculate which day of the week is today? (Week begins from Monday)

Col A Result Formula
15-Nov-19 5 =WEEKDAY(E54,2)