The Excel NETWORKDAYS Function

Related Functions:
NETWORKDAYS.INTL
WORKDAY

Basic Description

The Excel Networkdays function calculates the number of work days between two supplied dates (including the start and end date). The calculation includes all weekdays (Mon - Fri), excluding a supplied list of holidays.

The syntax of the function is:

NETWORKDAYS( start_date, end_date, [holidays] )

where the arguments are as follows:

start_date-

The start of the period for which we are counting days.

(The start date is counted in the returned number of days).
end_date-

The end of the period for which we are counting days.

(The end date is counted in the returned number of days).
[holidays]-An optional argument, which specifies an array of dates (in addition to weekends) that are not to be counted as working days.

Note that the start_date, end_date and [holidays] arguments should be input as either:

or

- If you attempt to input these date arguments as text, Excel may misinterpret them, due to different date systems, or date interpretation settings.


Networkdays Function Examples

The spreadsheets below provide two examples of the Excel Networkdays function, used to calculate the number of work days between the two dates 01-Dec-2010 and 05-Jan-2011.

One of the examples (in cell A8) ignores holidays (other than weekends), while the second example (in cell A9) provides a list of holidays to be excluded from the day count in the calculation.

 Formulas:
Examples of use of the Excel Networkdays Function
 Results:
Excel Networkdays Function Results

In the above spreadsheet:


Further examples of the Excel Networkdays function can be found on the Microsoft Office website.


Networkdays Function Errors

If you get an error from the Excel Networkdays function this is likely to be one of the following:

Common Errors
#VALUE!-Occurs if any of the supplied arguments are not valid dates.
#NAME?-

Occurs when Excel does not recognise a function name. This may be because you have made a mistake when typing the Networkdays function name into Excel.

Alternatively, this could be because the Analysis ToolPak add-in is not enabled in your Excel. You will need to enable this if you want to use the Excel Networkdays function.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010 or Excel 2013: