Excel Functions Tutorials
- Excel Formulas Cheatsheet
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- Date and Time Function in Excel
- Statistical Function in Excel
WEEKDAY Excel (Table of Contents)
WEEKDAY Function in Excel
Weekday Function in Excel is a function that returns a numeric value from 1 to 7, identifying the day of the week for a date as input. Excel Weekday function is categorized as Date/Time function. The WEEKDAY in Excel accepts a date argument and returns an integer between 1 and 7 that corresponds to the day of the week. The following Excel WEEKDAY formula, for example, returns 7 for a date – 04-August-2018.
WEEKDAY Formula in Excel
Below is the Excel WEEKDAY Formula.
Explanation of WEEKDAY Function in Excel
WEEKDAY Formula in Excel takes two arguments:
serial_number: Required input and it a date value for which we want the day of the week
return_type: is an optional field, a value ranging from 1-17 is an argument that specifies the day numbering system for the result. If you specify 2 as the second argument, the WEEKDAY Excel returns 1 for Monday, 2 for Tuesday, and so on. If you specify 3 as the second argument, the function returns 0 for Monday, 1 for Tuesday, and so on. In Later versions of Excel
return_type =1 (default value that is if we didn’t pass an optional argument, the function takes default value as 1)
return_type ranging from 11 to 17
WEEKDAY in Excel Output:
How to Use WEEKDAY in Excel?
WEEKDAY function in excel is very simple and easy to use. Let understand the working of WEEKDAY in excel by some examples.
WEEKDAY in Excel Example #1
Determining the weekday name in excel for the value returned as an output using Weekday Function in Excel:
For a given date we can determine the weekday name in excel using given below Excel WEEKDAY Formula.
The above WEEKDAY Formula in Excel work for the Weekday function with the return_type value as 1.
For return_type value 2, we have formulas
|=IF(WEEKDAY(A2,2)=7,”Sunday”,IF(WEEKDAY(A2,2)=1,”Monday”, IF(WEEKDAY(A2,2)=2,“Tuesday”,IF(WEEKDAY(A2,2)=3,”Wednesday”, IF(WEEKDAY(A2,2)=4,”Thursday”,IF(WEEKDAY(A2,2)=5,”Friday”,“Saturday”))))))|
For return_type value 3, we have the WEEKDAY formula in excel
For return_type value 3, we cannot use the choose function because the Weekday function in Excel results in first output as 0 for Monday and choose function first indexing starts from number 1.
Similarly, for other values of return_type, we can customize the Excel WEEKDAY Formula.
We can also use the TEXT function to display the weekday name in excel when a date is given
WEEKDAY in Excel Example #2 – Identify the Weekend Days
There is a list of random dates given in column A, we need to find the date is a weekend or a weekday.
We will be using the Weekday in excel to find which date is weekend. We know that the serial number for Saturday and Sunday is 7 and 1.
So, we will be using the IF condition along with OR logical function to check if the weekday number is 1 or 7, then the day is weekend else the day is a Weekday
So, the WEEKDAY formula in excel will be
Applying the Excel WEEKDAY formula to other cells we have
Similarly, we can identify other weekday name in excel also be it a Monday, Tuesday or any other day.
WEEKDAY in Excel Example #3
We have working hours of a freelancer who worked on different days, including weekends. If he works on a weekday the payout is $10/hour and if he works on a Saturday the payout amount is $15/hour. He worked for different hours each day (given below in table). We need to calculate his total payout amount.
The Weekday number value for Saturday is 7, so we will use the IF condition and check if workday is a Weekday or Saturday and will compute the result accordingly.
So, the WEEKDAY formula in Excel that we will be using is
Applying the WEEKDAY formula in excel to other cells we have,
The total payout amount is
Which is equal to $765.00
Things to Remember About WEEKDAY Function in Excel
- By default the return_type is always 1 that is if we omit return_type, then WEEKDAY function will take default value as 1.
- If the serial_number or return_type is out of range as specified above, #NUM! error is generated.
You can download this WEEKDAY Function in Excel template here – WEEKDAY Function Excel Template
This has been a guide to WEEKDAY in Excel. Here we discuss the WEEKDAY Formula in excel and how to use WEEKDAY function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –