Fresh Excel Tips

In this example a project has to be scheduled. Each of the five steps has a fixed start and end date. To determine the number of complete workdays between the start and end dates, the NETWORKDAYS function from the Analysis ToolPak add-in can be used. This function excludes weekends and any dates identified as non-workdays and holidays. The syntax is as follows:

NETWORKDAYS(start_date, end_date, holidays)
start_date: The start date.
end_date: The end date.
holidays: (optional) One or more dates that are to be excluded from the work schedule.

To determine the number of workdays:

1. In column B type the start date of each step.
2. In column C type the end date of each step.
3. List additional holidays in cells F2:F6.
4. Select cells D2:D6 and type the following formula: =NETWORKDAYS(B2,C2,$F$2:$F$6).
5. Press Ctrl+Enter.

1. How to use the WORKDAY function to calculate workdays in Excel
2. How to Use the YEARFRAC function to calculate employees ages
3. Use the DAYS360 function to calculate with a 360-day year
4. How to add months to a date using the DATE Function in Excel
5. How to Use the DATEDIF function to calculate the ages of employees