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

## 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)