Buzz
This article below introduces you to the WEEKDAY function - one of the functions in the date and time group that is widely used in Excel.
Description: This function returns the day of the week for a corresponding date. The returned value is an integer from 1 (Sunday) to 7 (Saturday).
Syntax: WEEKDAY(serial_number, [return_type])
Here are the details:
- serial_number: It represents the date value you want to determine the day of the week, which is a required parameter.
- return_type: It determines the type of return value, which is an optional parameter with the following values:
+ return_type = 1 or omitted -> It specifies values from 1 (Sunday) to 7 (Saturday).
+ return_type = 2 -> Determines values from 1 (Monday) to 7 (Sunday).
+ return_type = 3 -> Determines values from 0 (Monday) to 6 (Sunday).
+ return_type = 12 -> Determines values from 1 (Tuesday) to 7 (Monday).
+ return_type = 13 -> Determines values from 1 (Thursday) to 7 (Wednesday).
+ return_type = 14 -> Determines values from 1 (Friday) to 7 (Thursday).
+ return_type = 15 -> Determines values from 1 (Saturday) to 7 (Friday).
+ return_type = 16 -> Determines values from 1 (Sunday) to 7 (Saturday)
+ return_type = 17 -> Determines values from 1 (Sunday) to 7 (Saturday).
Note:
- Excel stores dates as serial numbers – consecutive numbers for easy calculation.
- If the serial_number is outside the basic range -> the function returns an error value #NUM!
- If the return_type is outside the defined value range -> the function returns an error value #NUM!
Example:
Find the day of the week for the dates in the table below using different return_type values:
- In the cell where you want to calculate, enter the formula: =WEEKDAY(E7,F7).
- Press Enter -> the returned value is:
- For the same date value but different return_type -> yields different results:
- In case of entering incorrect date data, here entering the month value = 15 -> the function returns an error value #VALUE!
- If the return_type value exceeds its range -> the function returns an error value #NUM!
Here is a guide and some specific examples of using the WEEKDAY() function in Excel.
Wishing you all success!
