The NETWORKDAYS function:

At Kevin’s request, I will show you how the NETWORKDAYS function works.

I have already told you how to calculate the number of days between two dates, in one of the previous tips.
You need to specify the start and end dates.
In the example below, this is cell D3 minus cell D2, or as a formula = D3-D2
The result is 44 days.

In order to calculate the number of days, however, we use the NETWORKDAYS function.
This function takes three arguments.
A “Start Date” (1), an “End” Date (2) and a range for the holidays (3).
The first two arguments are mandatory.
The third one, i.e, “Holidays”, is optional.
A useful tip:
When there is an argument in a function which is enclosed in square brackets, such as the holidays, then this argument is always optional and, therefore, need not be completed.

As always, you start a formula with the equal sign (=).
Then type the NETWORKDAYS function and open the brackets (
Then select the cell in which the start date is indicated, which is E2, in this case.
You type a comma (,) and select the cell containing the indicated date.
In this case, it is E3.
You close the brackets ) and press the Enter key on your keyboard.

It is important to know that this function has to have the start date and end date.
So, in order to count the days in between, you must subtract two from this formula (A).

However, if you would do not want to count certain days, such as the holidays, in the net working days, then you can use the third argument.

So, after typing the second argument, which is the end date, type another comma (,).
You select the range with the dates that are not be counted. In this case, the Holidays are in cellsA2: A14.
You can then close the brackets ).
Press the Enter key on keyboard.

I know what you’re thinking:
“There are three holidays” for this period in this range, and he considers only one?”
That’s right.
But there’s only one that does not fall on weekends, which is Monday, April 25.

FYI: Swotster.com thinks of its students, so you also remember swotster.com

Copyright © 2013 – Swotster Ltd.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats