NETWORKDAYS Formula in Excel

 

What Does It Do?

This function will calculate the number of working days between two dates.

It will exclude weekends and any holidays.

Syntax

=NETWORKDAYS(StartDate,EndDate,Holidays)

Holidays : This is a list of dates which will be excluded from the calculation, such as Xmas and Bank holidays.

Formatting

The result will be shown as a number.

Note

The calculation does not include the last day. The result of using 1-Jan-98 and 5-Jan-98 will give a result of 4. To correct this add 1 to the result. =NETWORKD

Example

The following example shows how a list of Holidays can be created.

AYS(Start,End,Holidays)+1