NETWORKDAYS Function (Table of Contents)
NETWORKDAYS in Excel
In any business, we need to calculate employee benefits based on working days. Or calculating the number of working days during a project, or how much number of business days required for resolving a ticket raised by a customer etc.
These above kinds of issues can be solved by using the NETWORKDAYS Function.
What is the NETWORKDAYS Function in Excel?
The NETWORKDAYS Function calculates the number of working days between two dates in excel. This function automatically excludes weekends (Saturday and Sunday) and holidays. This function also excludes the specified holidays from the working day calculation.
The NETWORKDAYS Function is a built-in function in excel and it falls under Date/Time functions category. This function is also known as Worksheet Function in excel. Thus, the NETWORKDAYS Function can be used as part of a formula in a cell of a worksheet.
NETWORKDAYS Formula in Excel
Below is the NETWORKDAYS Formula in Excel :
Where the supplied arguments are as follows:
- Start_date – The start_date from where you want to start the calculation of work days.
- End_date – The end_date up to which you want to calculate working days.
- Holidays – This is an optional argument. It is the list of holidays (one or more dates) that we want to exclude from the working day’s calculation. This list can be entered as a cell, range of cells or an array containing dates.
As worksheet function, the NETWORKDAYS Function can be entered in excel as per below screenshot:
The NETWORKDAYS Function is a built-in function in excel, thus it can be found under FORMULAS tab. Please follow below steps:
- Click on FORMULAS tab.
- Select the Date & Time functions category.
- It will open up a drop-down list of functions. Select the NETWORKDAYS Functions from the drop-down list.
- It will open a dialog box of Function arguments.
- Fill the start_date field, it can be entered as a serial data which is used to calculate the working days.
- Fill the end_date field, it can be entered as serial date and used in the calculation.
- Enter the holiday’s field, which is an optional argument. It is the set of one or more dates which we want to exclude from the working day’s calculation.
How to use the NETWORKDAYS Function in Excel?
NETWORKDAYS Function is a very simple and easy to use. Let us now see how to use this NETWORKDAYS Function with the help of some examples.
Let’s take some dates as start date and end date.
Below dates are the holidays in between:
Now for calculating the number of working days the start date, end date and holidays date have been entered as serial dates.
The result will be :
Drag & drop this formula for the rest values and the final result are as shown below:
It depends on the solution, that does we want to exclude only weekends or do we want to also exclude the holiday dates too from the working day’s calculation.
We have given below dates and we will do both types of calculations:
Apply NETWORKDAYS Function to the cell E26.
The Result will be :
The final result is shown below:
Things to remember about the NETWORKDAYS Function in Excel :
- NETWORKDAYS Function automatically excludes both Saturday and Sunday (takes both as weekends). If you want to use different days like weekends, you need to use a different function for this i.e. NETWORDAYS.INTL function.
- If you are passing a range of cells for the holidays, make the range as an absolute value. So that the range will not change, if you drag this formula to other cells.
- The function returns the #VALUE! error value, if any date passed as an argument is not a valid date.
- If the start date is later than the End date, the NETWORKDAYS Function will return a Negative value.
This has been a guide to NETWORKDAYS Function in Excel. Here we discuss the NETWORKDAYS Formula in Excel and How to use NETWORKDAYS Function in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –