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