How Excel Tutorials Find the number of working days in a specified interval

If can be directly in the form of easy to calculate, so the personnel in the Personnel department to get a lot of help, in the end is how to achieve, below a look at it.

Specific steps to operate:

1, open a need to calculate the working day of the table, we in the D2 cell input formula: =networkdays (B2,C2).

2, enter the results of 21, in January 2010, out of Saturday and Sunday, the working day has 21 days.

3, double-click the fill handle, pull down to get the result, we check without format fill.

4, then enter the formula in the E11: =networkdays (B11,C11,A16:A18).

5, carriage return results show 20, which does not include holidays, that is, National day.