Using the NetWorkDays Function in Excel

The NetWorkDays fuction in Excel can be used to give you the net amount of work days. A good use for this function is project planning.  The example below shows the start and end date for a project, the planned vacation days and the final number of work days (without the vacation).

Syntax:   =NetWorkDays({Begin Date},{End Date},{Range of off days/holidays})

=NETWORKDAYS(B1,B2,D6:D10)

As you can see this fuction comes in handy in plannning a project.

[-Related Links-]
Better Solutions – NetWorkDays
Distributing Days Over Intervals