Microsoft Office Tutorials and References
In Depth Information
Working with Workdays
Figure 12-9 shows an example using NETWORKDAYS. Cells C3 and C4 show
the start and end dates, respectively. In this example, the start date is
provided with the TODAY function. Therefore, the result will always reflect
a count that starts from the current date. The end date is the last day of the
year. The function in cell C6 is =NETWORKDAYS(C3,C4,C10:C23).
The function includes the cells that have the start and end dates. Then there
is a range of cells — C10 through C23. These cells have dates that should
not be counted in the total of workdays: holidays and vacation. You can put
anything in here, but they do have to be Excel dates. If a date specified in this
list falls on a workday, then NETWORKDAYS does not count it. If it falls on a
weekend, it would not be counted anyway, so it is ignored.
To use NETWORKDAYS, follow these steps:
1. Select the cell where you want the results displayed.
2. Enter =NETWORKDAYS( to begin the function entry.
3. Click the cell that has the start date for the range of dates to be
4. Enter a comma ( ,).