Excel NETWORKDAYS Function

HomeExcel FunctionsExcel NETWORKDAYS Function (Example + Sample File)

What is EXCEL NETWORKDAYS FUNCTION

The Excel NETWORKDAYS Function is listed under Microsoft Excel's Date Functions category. It returns the count of days between the start date and end date. In simple words, with NETWORKDAYS you can calculate the difference between two dates, after excluding Saturdays and Sundays, and holidays (which you specify).

How to use it

To learn how to use the NETWORKDAYS function in Excel, you need to understand its syntax and arguments: 

Syntax

NETWORKDAYS(start_date,end_date,holidays)

Arguments

  • start_date: A valid date from where you want to start your calculation.
  • end_date: A valid date up to which you want to calculate working days.
  • [holidays]: A valid date that represents a holiday between the start date and end date. You can refer to a cell, range of cell or an array containing dates.

Notes

  • This function is a part of the Analysis Tool Pack.
  • It will not include Saturday and Sunday by default.

Example

To master the NETWORKDAYS function we need to try it out in an example and below is one which you can try out:

In the below example, we have specified 10-Jan-2015 as a start date and 20-Feb-2015 as an end date.

We have 41 days between these two dates, out of which 11 days are weekends. After deducting those 11 days it has returned 30 working days.

Now in the below example with the same start and end dates, we have specified a holiday and, after deducting 11 days of the weekend and 1 holiday it has returned 29 working days.

Again with the same start and end dates, we have used a range of three cells for holidays to deduct from the calculation and, after deducting 11 weekend days and 3 holidays which I have mentioned It has returned 27 working days.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.