Author: Mary Ann Richardson [Source: http://blogs.techrepublic.com.com/msoffice/?p=591&tag=leftCol;post-611]
You don’t need to count out days on a calendar to find out how many days you have to complete a project. Excel’s NETWORKDAYS function can calculate it for you — without requiring you to work weekends or holidays.
To set up a worksheet that will calculate the number of working days excluding weekends and holidays from a project’s start date to its due date, follow these steps:
- Enter the headings for Project, Start Date, End Date, and Work Days as shown.
- Select B2:C2.
- Press Shift+ Ctrl + Down Arrow.
- Right-click the selection and choose Format Cells.
- Select Date under Category and 3/14/01 under Type.
- Click OK.
- Select J2.
- Press Shift+ Ctrl + Down Arrow.
- Right-click the selection and choose Format cells.
- Select Date under Category and 14-Mar-01 under Type.
- Click OK.
- Complete the Holiday Table as shown.
- Select J2:J9.
- Click in the Name box and enter Holidays_2008.
- Click D2 and enter the following formula:
=NETWORKDAYS(B2,C2,Holidays_2008)
- Copy the formula in D2 to the D3:D4 to obtain the number of Workdays for Projects B and C.
