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.
Objective: Identify today's weekday number basis different return_type value
Objective: Return the weekday of the date given in 'Date Input'
Objective: Calculate which day of the week is today? (Week begins from Monday)