# 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:

• References to cells containing dates
or
• Dates returned from formulas.

- 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: Results: