WEEKDAY function - The function returns the weekday of a corresponding date in Excel
The following article introduces you to the WEEKDAY function - one of the functions in the date and time group function is very popular in Excel.
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!
You should read it
- DAY function - The function returns the date value of a specific date in Excel
- DATE function - The date function in Excel
- TODAY function - The function returns the current date value in the format in Excel
- COUPNCD - The function returns the next coupon date in Excel
- The DAY function - The function returns the day of the day, month and year in Excel
- YEAR - The function returns the year corresponding to a date in Excel
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
May be interested
- Date functions in Excel, DAY, WEEKDAY, MONTHdo you want to automatically update the current date, separate years or calculate the distance between two time points? the article below, free download will guide you how to do this professionally with date functions in excel.
- COUPPCD - The function returns the previous coupon date before the settlement date in Excelin the previous article introduced to you the function returns the next coupon date after the settlement date. the following article introduces you to the couppcd function - the function returns the previous coupon date before the settlement date.
- Excel date function - Usage and examplesthe date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake.
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excelisoweeknum function: the function returns the ordinal number of the year of the week that contains the given date. syntax: isoweeknum (date)
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)