What is WEEKDAY function in Excel?
The WEEKDAY function is one of the Date & Time functions of Excel.
It Returns a number from 1 to 7 identifying the day of the week of a date.
We can find this function in Date & Time category of insert function Tab.
How to use WEEKDAY function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Date & Time category.
5. Select WEEKDAY function
6. Then select ok.
7. In the function arguments Tab you will see WEEKDAY function.
8. Serial number is a number that represents a date.
9. Retum_type is a number for (Sunday=1 through Saturday=7), use 1;
for (Monday=1 through Sunday=7), use 2;
for (Monday=0 through Sunday=6), use 3.
10. You will see the result in the formula result section.
Examples of WEEKDAY function in excel
example 1:
How to calculate the days of week in Excel?
In the following example, as you can see in the photo, days of week can be identified by the WEEKDAY function.
=WEEKDAY(9/18/2022,1) ----->>>>answer is 1
=WEEKDAY(9/18/2022,2) ----->>>>answer is 7
=WEEKDAY(9/18/2022,3) ----->>>>answer is 6
=WEEKDAY(10/18/2022,1) ----->>>>answer is 3
=WEEKDAY(11/18/2022,2) ----->>>>answer is 5example 2:
How to Show dates as days of the week?
It can be determined by combining two functions TEXT and WEEKDAY.
=TEXT(WEEKDAY("9/18/2022"),"ddd") ----->>>>answer is Sun
=TEXT(WEEKDAY("10/18/2022"),"ddd") ----->>>>answer is Tue
=TEXT(WEEKDAY("11/18/2022"),"ddd") ----->>>>answer is Friexample 3:
TEXT and WEEKDAY and DATE function
we can use Date function instead of “date”.
=TEXT(WEEKDAY(DATE(2022,9,18)),"ddd") ----->>>>answer is Sun
=TEXT(WEEKDAY(DATE(2022,10,18)),"ddd") ----->>>>answer is Tue
=TEXT(WEEKDAY(DATE(2022,11,18)),"ddd") ----->>>>answer is Friexample 4:
Different Types of Date Formats
we can use all types of date format in WEEKDAY function.
=TEXT(WEEKDAY(A2),"ddd") ----->>>>answer is Sunexample 5:
DATEVALUE and DATE function
we can use Datevalue function instead of “date”.
What is the purpose of WEEKDAY function?
It Returns a number from 1 to 7 identifying the day of the week of a date.
What is the Return value of WEEKDAY function?
How many arguments does WEEKDAY function have?
This function has just 2 Argument.
The argument of WEEKDAY function is number.
The argument of WEEKDAY function is required and not optional.
Which version of excel supports WEEKDAY function?
This function is available for all excel versions (2003-2019)
Errors in WEEKDAY function
WEEKDAY related functions
- Use WEEKNUM function to return the week number in the year.
- Use ISOWEEKNUM function to return the ISO week number in the year for a given date.
