Use the NETWORKDAYS function to determine number of workdays
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:
- In column B type the start date of each step.
- In column C type the end date of each step.
- List additional holidays in cells F2:F6.
- Select cells D2:D6 and type the following formula: =NETWORKDAYS(B2,C2,$F$2:$F$6).
- Press Ctrl+Enter.
- How to use the WORKDAY function to calculate workdays in Excel
- How to Use the YEARFRAC function to calculate employees ages
- Use the DAYS360 function to calculate with a 360-day year
- How to add months to a date using the DATE Function in Excel
- How to Use the DATEDIF function to calculate the ages of employees
