The NETWORKDAYS Function Knowledgebase In Excel

Quantunet.com

My Account

Joins Us

Excel QuickSkills

The NETWORKDAYS() Function Knowledgebase

The NETWORKDAYS function returns the number of workdays between two dates. This excludes weekends and any dates recognized as holidays.

The syntax for the function is NETWORKDAYS (start_date, end_date, holidays) .

The "start date" and "end_date" must be a string or a recognizable date format in Excel. The "holidays" can be a range of cells containting holiday dates or a series of date values representing dates.

Note: It is better to enter the dates into this function using the DATE() function as dates in the forma of text strings can cause problems to occure.

How to use the NETWORKDAYS() function:

Type " =NETWORKDAYS( "
Enter the coordinate for the "Start Date" data cell "A2"
Type a comma.
Enter the coordinate for the "End Date" datas cell "B2".
Type comma.
Enter the coordinate for the "Holidays" data cell "C2"
Type ")" then press the "Enter" key.

This function uses the date values to directly calculate the number of days beteen dates and then subtracts the number of weekends and noted holidays. [The DATEVALUE() function]