**NETWORKDAYS Function in Excel:** We all know that Excel is a powerful spreadsheet program, that provides various **formulas **and **functions **to perform mathematical calculations. On that note, NETWORKDAYS is one of the built-in functions in Excel. It helps to **find the working days between the given two dates**.

If you want to find the NETWORKDAYS on your Excel worksheet, then we will guide you to know how to use this function. Here, we discuss the **description, basic syntax, and usage of the NETWORKDAYS Function in Excel**. Get the official version of **MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of NETWORKDAYS** **Function

- The
**NETWORKDAYS Function**returns the**number of working days between two dates**. - You will be needed to give
**start_date**and**end_date**so that the function will calculate the number of working days and produce the output. - This function will automatically
**exclude Saturdays and Sundays**while calculating the number of working days. - You can also specify the dates of holidays so that it treats as non-working days, and it will not include in the output.

**Syntax**

- Here, you will see the syntax of the NETWORKDAYS function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=NETWORKDAYS(start_date,end_date,[holidays])**

**Parameters Explanation**

**Start date (Required):**The start date to be used in the calculation.**End date (Required):**The end date to be used in the calculation.**Holidays (Optional):**It is the list of holidays to exclude from the calculation.

**Note:** **#VALUE! Error:** NETWORKDAYS Function will return **#VALUE!** error if any argument is not a valid date.

## Practical **Examples**

Let’s look at some examples of the **NETWORKDAYS**** function** and explore how to use it in Microsoft Excel.

- Initially, you have to
**open**your**Excel workbook**on your PC and launch a worksheet that has data. - For instance, we have entered Input values of
**start_date**&**end_date**in**B3**and**C3**cells. - You need to know that, Excel automatically excludes
**Saturdays**and**Sundays**.

- Then, you have to
**enter the formula**and**hit**the**Enter**button to get the result.

- After executing the formula, you will get the result, as shown in the below screenshot.

- Let’s see one more example to make it clear. We will calculate the
**number of working days by excluding a given holiday**. - Input values of
**start_date**,**end_date**&**holiday**are entered in**B3**,**C3**, and**D3**cells.

- Once you apply the NETWORKDAYS function, you will get the result as shown in the below image.

**Note:** You don’t have to mention any holiday date of Saturdays or Sundays separately in the holiday parameter. Excel will already **exclude** those **Saturdays **& **Sundays **in the calculation.

- This example will calculate the number of working days by
**excluding four given holidays**. - For that, you need to
**apply the formula**, as shown in the below screenshot.

- After executing the formula, you will get the output, as shown below.

**Verdict**

In the above short article, we have illustrated the definition, syntax, and usage of the **NETWORKDAYS function** with a few practical examples. We hope that the given screenshots let you understand it quickly.

If you have any doubts regarding how to use this function in Excel, kindly **comment **in the following section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to apply the **NETWORKDAYS function** in the Excel spreadsheet.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.