When calculating the difference between two dates, you may want to exclude weekends and holidays. For example, you may need to know how many business days fall in the month of November. This calculation should exclude Saturdays, Sundays, and holidays. The NETWORKDAYS function can help out.

The NETWORKDAYS function calculates the difference between two dates, excluding weekend days (Saturdays and Sundays). As an option, you can specify a range of cells that contain the dates of holidays, which are also excluded. Excel has absolutely no way of determining which days are holidays, so you must provide this information in a range.

Figure 16-4 shows a worksheet that calculates the work days between two dates. The range A2:A11 contains a list of holiday dates. The two formulas in column C calculate the work days between the dates in column A and column B. For example, the formula in cell C15 is:

=NETWORKDAYS(A15,B15,A2:A11)

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 work days in the year.

FIGURE 16-4
Using the NETWORKDAYS function to calculate the number of working days between two dates.

• DVD-Easy Steps to Acoustic Blues Guitar #1- Starting From Scratch User Reviews Send this to a friend DVD-Easy Steps to Acoustic Blues Guitar #1- Starting From Scratch Manufacturer: Homespun Tapes...
• Best Skis for Alpine Skiing Having the right skis when you go alpine skiing is absolutely vital if you want to get the most out...
• Wilson Electronics Sleek Cell Phone Car Signal Booster Unboxing And Initial Thoughts I would first like to thank Ken from Wilson Electronics for sending me a review unit so i could test...
• Frugal Holiday Gift Ideas Were you up and out at 4:00am to take advantage of Black Friday sales? Me neither.  I prefer to do...
• Last Minute Gifts For The Frugals On Your List Over the years I've tried to compile a few last minute gift ideas. Oddly enough, I nearly waited until the...