Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Using MS Excel's Networkdays Function

By Deborah J. Sparks

QUESTION:

"How can I figure out the number of working days, excluding weekend and holidays, between two dates?"



ANSWER:

Use the NETWORKDAYS function:

Trying to calculate vacation entitlement or determine the number of working days for a project that has a set end date? Try the NETWORKDAYS function. Here are the components:

  • The start date
  • The end date
  • Holidays (optional)

You can key in the dates and number of statutory holidays, or simply refer to cell addresses that contain this information.

Here is the formula used for the worksheet below:

=NETWORKDAYS(B2,A2,C2:C3)


Note: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in from the Tools menu.


There are many other date formulas and functions, including DAYS360, in Excel that will help you get the results you need.



More Newsletter Articles

© 2009 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.