Calculates the number of whole working days between two dates. This means that weekends and holidays are excluded.
The syntax of the function is the following:
NETWORKDAYS(end_date, start_date, [holidays])
end_date: The end date of the period’s length in days we wish to calculate.
start_date: The start date of the period’s length in days we wish to calculate.
[holidays]: Optional. A range of dates that are considered holidays.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the NETWORKDAYS function:
Complete the cells C2:F2 following the instructions in the cells C1:F1.
C2: Subtract start date from enddate
D2: use the hidden datedif function to find the difference in days between the dates in A2:B2
E2,F2: use the functions shown in the first row to find the difference in days between the dates in A2:B2