Note: If you have limited experience with Excel try the Excel NETWORKDAYS Function Step by Step Tutorial which includes detailed information about using this function.
This tutorial is intended for users familiar with using Excel's date functions.
Excel NETWORKDAYS Function Quick Tutorial
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.
If you need to use weekend days other than Saturday and Sunday and you are using Excel 2010, try using the Excel 2010 NETWORKDAYS.INTL Function
NETWORKDAYS Function Syntax and Arguments
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
For help with this example, see the image above.
- 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.