The NETWORKDAYS function, one of Excel's Date and Time functions, can be used to count the number of working days between two dates. The function automatically removes weekend days from the total. Specific holidays can also be omitted.
The syntax for the NETWORKDAYS function is:
= NETWORKDAYS ( Start_date , End_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).
Counting Days Between Two Dates Example
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
