# How to Calculate Working Days in Excel Excluding Weekends and Holidays

Get FREE Advanced Excel Exercises with Solutions!

Finding the total number of working days between two dates in Excel is a frequently needed function. Usually, we overlook the weekends and holidays when calculating this. To exclude weekends and holidays from the count of workdays, Excel offers two distinct functions. In this article, we will discuss 2 ways of calculating working days in Excel, excluding weekends and holidays.

In this article, we will discuss 2 handy ways to calculate working days in Excel, excluding weekends and holidays. Firstly, we will use the NETWORKDAYS function to calculate the workdays for two cases, one considering only the weekends and the other considering both weekends and holidays. Then, we will use the NETWORKDAYS.INTL function to calculate workdays for both cases mentioned earlier.

## 1. Using NETWORKDAYS Function to Calculate Working Days in Excel Excluding Weekends and Holidays

The NETWORKDAYS function calculates the number of workdays between two dates considering both weekends and holidays. This function assumes that the weekend is on Saturday and Sunday. We will use it to calculate the total number of workdays between two dates, considering weekdays as well as holidays.

### 1.1 Excluding Only Weekends

In this method, we will use the NETWORKDAYS function and consider only the weekends.

Steps:

• Select the E5 cell and write down the following formula,
`=NETWORKDAYS(B5,C5)`
• Then, hit Enter.

• Consequently, we will get the net workdays excluding the weekends.
• Then, pull the cursor down to the last data cell to get the values for all the data.

### 1.2 Excluding Both Weekends and Holidays

In this instance, we will consider weekends and holidays when calculating the net workdays.

Steps:

• To begin with, select the E5 cell and then write the following formula down,
`=NETWORKDAYS(B5,C5,\$D\$13:\$D\$15)`
• In this case, the (\$D\$13:\$D\$15) denotes the holidays.
• Then, hitÂ Enter.

• Consequently, we will get the net workdays excluding the weekends as well as the holidays.
• Next, lower the cursor to the last data cell.
• Excel will automatically fill the rest of the cells according to the formula.

## 2. Applying Excel NETWORKDAYS.INTL Function to Calculate Working Days Excluding Weekends and Holidays

In this method, we will count the workdays using the NETWORKDAYS.INTL function. Here, we will consider weekends other than the regular Saturday and Sunday weekends.

### 2.1 Excluding Only Weekends

In this instance, we will calculate the net workdays excluding only the weekends.

Steps:

• Firstly, choose the E5 cell and write down the following formula,
`=NETWORKDAYS.INTL(B5,C5,7)`
• Then, hit Enter.

• As a result, we will receive the net workdays excluding weekends.
• Afterward, move the cursor down to the final data cell to obtain the values for all the data.

In this case, the third argument is 7 which denotes a Friday and Saturday weekend. The following is the list of numbers that denote different weekends.

### 2.2 Excluding Both Weekends and Holidays

In this case, we will use the NETWORKDAYS.INTL function to get the values of total workdays between two dates. In this case, we will keep in mind not only the weekends but also the holidays.

Steps:

• To start with, choose the E5 cell and write down the following formula,
`=NETWORKDAYS.INTL(B5,C5,7,\$D\$13:\$D\$15)`
• Then, hit the Enter button.

• As a result, we will get the total workdays excluding the weekends and holidays.
• Next, move the cursor down to the last data cell.
• The rest of the cells will be automatically filled according to the formula.

## Conclusion

This article is about counting the number of working days in Excel excluding the weekends and holidays. As you can see, there are two functions which are used to calculate the working days. The procedure is very simple and doesnâ€™t require too many options.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Siam Hasan Khan

Hello! Welcome to my Profile. Here I will be posting articles related to Microsoft Excel. I have completed my BSc in Electrical and Electronic Engineering from American International University-Bangladesh. I am a diligent, goal-oriented engineer with an immense thirst for knowledge and an attitude to grow continuously. Continuous improvement and life-long learning are my mottoes.

1. happy, thank you sir

• You are welcome.

2. This is very good. Loved the article.

Thanks for the feedback.

3. can the NETWORKDAYS (or a similar function) be used without having to manually enter all of the weekend and holiday dates?

4. Hi, Kawser

Thanks you so much, you are making people life easy and Inshallah ALLAH will pay you back.

Have a wonderful time

Thanks
M. Shakeel

• Thanks for your Prayer, Shakeel!
Best regards
Kawser

Advanced Excel Exercises with Solutions PDF