Excel WEEKDAY Function

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

1. 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  5

example 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  Fri

example 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  Fri

example 4:

Different Types of Date Formats

we can use all types of date format in WEEKDAY function.

=TEXT(WEEKDAY(A2),"ddd") ----->>>>answer is  Sun

example 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.