Microsoft Office Tutorials and References

In Depth Information

Figure 6-4:
Using the NETWORKDAYS function to calculate the number of working days between two dates.

This formula returns
4,
which means that the seven-day period beginning with January 1 contains four work-

days. In other words, the calculation excludes one holiday, one Saturday, and one Sunday. The formula in cell

C16 calculates the total number of workdays in the year.

Excel 2010 introduced an updated version of the NETWORKDAYS function, named

NETWORKDAYS.INTL. This new version is useful if you consider weekend days to be

days other than Saturday and Sunday.

This workbook, work days.xlsx, is available at this book's website.