Table of Contents
This guide explains how to use WEEKDAY Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the day of the week for the corresponding day. The return value is an integer between 1 (Sunday) and 7 (Saturday).
Syntax: WEEKDAY (serial_number, [return_type])
Inside:
- serial_number: Date value to determine the day, is a required parameter.
- return_type: The value that determines the return type, is an optional parameter with the following values:
+ return_type = 1 or skip -> Specify value = 1 (Sunday respectively) until 7 (Saturday).
+ return_type = 2 -> Specify value = 1 (2nd correspondence) until 7 (Sunday).
+ return_type = 3 -> Specify value = 0 (2nd correspondence) until 6 (Sunday).
+ return_type = 11 -> Specify value = 1 (2nd correspondence) until 7 (Sunday).
+ return_type = 12 -> Specify the value = 1 (3rd correspondence) until 7 (2nd).
+ return_type = 13 -> Specify the value = 1 (corresponding to the 4th) until 7 (the 3rd).
+ return_type = 14 -> Determine the value = 1 (corresponding to the 5th) to 7 (the 4th).
+ return_type = 15 -> Specify the value = 1 (6th order) until 7 (5th).
+ return_type = 16 -> Specify value = 1 (corresponding to the 7th) to 7 (the sixth)
+ return_type = 17 -> Specify value = 1 (Sunday) until 7 (Saturday).
Attention:
- Excel stores dates as sequential serial numbers to facilitate the calculation process.
- If serial_number is outside the base range price -> the function returns the #NUM! Error value
- If return_type is outside the range of values specified above -> the function returns the #NUM! Error value
For example:
Find the dates of the following dates in different return_type values:
- In the cell to calculate enter the formula: = WEEKDAY (E7, F7).
- Press Enter -> return value is:
- With the same date value but different return_type return type -> for different results:
- In case of entering the wrong date data, here enter the month value = 15 -> function returns the error value #VALUE!
- If the return_type value is outside its range -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using WEEKDAY () function in Excel.
Good luck!
FAQ
What does the WEEKDAY function do in Excel?
The WEEKDAY function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the WEEKDAY function correctly?
Start with an equals sign, enter WEEKDAY, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the WEEKDAY function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Related Articles
DATE Function: Converts Numbers to a Valid Date Format5 minutes read
How to Use the DAY Function in Excel2 minutes read
How to Use the NOW Function in Excel3 minutes read
DATE Function in Excel: Syntax and Examples3 minutes read
COUPNCD - the Function Returns the Next Coupon Date in Excel4 minutes read
YEAR - the Function Returns the Year Corresponding to a Date in Excel2 minutes read
Reader Comments 0
Sign in with email or Google to join the discussion.