EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF

Networkdays

Very often when working with Microsoft Excel the difference between two dates is needed. Recently I was working on a project calculating the wages for a group of employees. One of the pivotal functions in this exercise was called Networkdays. What I like about this function is that it excludes weekends and holidays when calculating the number of days between dates. This exclusion ability makes it more accurate than other techniques. In the following tutorial we will contrast Networkdays with another approach.
Below we have a table containing 200 employees. Each employee has different daily wages and work end dates. These two variables imply a different total wage for each employee.

1. We need to populate the number of days worked in this column

2. Type in the function =Networkdays(D3,E3)

a. =Networkdays(Start_Date, End_Date, Holiday)

3. The networkdays function has returned the number 6. This means 6 work days appear between 9/1/2013 and 9/9/2013.

4. Notice the total wage is $97.50.




Alternative Date Difference Technique

1. Type in =E3-D3

a. End date – Start date

2. This technique produces a value of 8. This means 8 days appear between 9/1/2013 and 9/9/2013.

3. Notice the total wage is $130.

Here we contrasted two techniques for getting the number of days between two dates. In this situation Networkdays would be the more accurate function. The alternative method overstates the number of days worked which in turn affects the wages earned.


Footer

Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.