The NETWORKDAYS function, one of Excel's Date and Time functions, can be used to calculate the number of working days during a specific time period. The function automatically removes weekend days from the total. Specific holidays can be omitted as well.
The syntax for the NETWORKDAYS function is:
= NETWORKDAYS ( Start_date , nd_date , Holidays )
Start_date - the start date of the chosen time period.
End_date - the end date of the chosen time period.
Holidays - can be used to exclude one or more dates from the total number of working days (optional).
Example Using Excel 2007's NETWORKDAYS Function:
Note: For help with this example, see the image to the right.
- Enter the following data into the appropriate cell:
D1 - Start:
D2 - Finish:
D3 - Holiday 1:
D4 - Holiday 2:
E1 - 7/7/2008
E2 - 11/7/2008
E3 - 9/8/2008
E4 - 10/13/2008
Note: If the dates in cells E1 to E4 do not appear correct, check to see that these cells are formatted for dates.
- Click on cell F1 - the location where the results will be displayed.
- Click on the Formulas tab.
- Choose Date and Time functions > NETWORKDAYS from the ribbon to bring up the
function's dialog box.
- Click on the Start_date line in the dialog box.
- Click on cell E1 in the spreadsheet.
- Click on the End_date line in the dialog box.
- Click on cell E2 in the spreadsheet.
- Click on the Holidays line in the dialog box.
- Drag select cells E3 and E4 in the spreadsheet.
- Click OK in the dialog box.
- The number of working days - 88 appears in cell F1.
- There are 90 weekdays between the start and end dates. From this number the two holidays in cells E3 and E4 are subtracted to leave 88 working days.
- When you click on cell F1 the complete function
= NETWORKDAYS ( E1 , E2 , E3 : E4 ) appears in the formula bar above the worksheet.
Related Articles
