# 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.

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)