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.