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.
Syntax
WEEKDAY (serial_num, [return_type])
Parameter
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.
Category
Date & Time
Return
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) |