How to use the NETWORKDAYS function in Excel
How to use the NETWORKDAYS function in Excel
Learn how to use the NETWORKDAYS function in Microsoft Excel. This tutorial demonstrates how to use Excel NETWORKDAYS with an easy to follow example. The NETWORKDAYS function allows you to calculate the number of work days between two dates and exclude weekends and holidays from the calculation.
NETWORKDAYS Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.02 -> The NETWORKDAYS function is
a helpful Date function in Excel
4.84 -> The NETWORKDAYS function allows you to calculate
the number of workdays between two dates
10.1 -> where you can exclude
both weekends and holidays
13.74 -> To illustrate how to use the NETWORKDAYS function,
let's look at an example
19.4 -> Here we have a table of data
with a "Start Date" and an "End Date"
23.8 -> Let's use the NETWORKDAYS function to calculate
the number of workdays between these two dates
30.1 -> Notice that we've also specified 4 holidays that
we want to exclude from our workday calculations
36.26 -> To get started, let's begin by entering
the NETWORKDAYS command
41.36 -> As you can see, the NETWORKDAYS function
takes 3 parameters
46.08 -> The first parameter you must enter is
the start_date to use in the calculation
51.02 -> This date should be entered as
a serial date and not a text date
55.72 -> A serial date is how Excel stores
dates internally
59.48 -> and it represents
the number of days since January 1, 1900
64.16 -> In this example, let's enter A2
as our start_date
68.48 -> Cell A2 contains
the value Dec 30, 2015
73.4 -> The second parameter we will need to enter
is the end_date to use in the calculation
79.28 -> Just like the start_date,
the end_date must also be a serial date
83.92 -> We will enter B2 as our end_date which
contains the value Dec 31, 2015
90.32 -> The third parameter is optional
93.3 -> It is a list of holidays to exclude from the
workday calculation
97.42 -> it can be entered either
as a range of cells
100.5 -> or as a list of serial numbers
that represent the holiday dates
104.04 -> In this example, we will
enter the range F2:F5
109.29 -> This range contains 4 holidays that we want
to exclude from our workday calculation
114.6 -> Notice that we have "absolutely referenced" this range
by using the dollar sign character ($)
120.06 -> so that when we copy our formula later,
it will properly reference this range of holidays
124.9 -> Now that we have entered all of
the parameters for the NETWORKDAYS function
129.5 -> let's complete the command
to look at our result
132.16 -> You should see
the value 2 appear in cell C2
136.08 -> This is the number of workdays between
the dates Dec 30, 2015 and Dec 31, 2015
144.28 -> Now let's copy our formula
into cell C3 to C5
149.62 -> Each of these cells now contain the number of workdays
between their corresponding start and end dates
157.14 -> This completes our example of how
to use Excel's NETWORKDAYS function
162.36 -> If you would like to see
more NETWORKDAYS examples
165.5 -> or would like to download
the sample data we used for this tutorial
169.08 -> please visit our website at TechOnTheNet.com
171.9 -> If you found our tutorial helpful,
please leave a like on this video
176.18 -> and don't forget to subscribe to
our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=0vtOtQhtA-Q