Calculating the number of work days between two dates
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.
// Related Posted - GOOGLE!
Related Websites
- How To Make International Dating Services Work For You Are you interested in expanding your dating pool and considering joining an international dating service? They are becoming increasingly popular,...
- Travel Guide:World Cup 2010 [/caption] South Africa is a large, diverse and incredibly beautiful country. The size of France and Spain combined, and roughly...
- Sheer Stella Perfume Review This is a review of the Sheer Stella perfume, a perfume for women by Stella McCartney. The Sheer Stella perfume,...
- 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...
- Strawberry Farms Golf Course, Irvine, CA Strawberry Farms Golf Course is located in: Irvine, CA Phone: (949) 551-1811 Website: http://www.strawberryfarmsgolf.com/contact/ About the Course: Strawberry Farms is...
