NETWORKDAYS function

  • Thread starter Thread starter brianwa
  • Start date Start date
Yes, it is part of the ATP add-in (analysis toolpak), it comes with excel or
office,
but it has to be installed..
 
Yes, the NETWORKDAYS (Net Workdays, not Network days) function return the
number of working days (Monday through Friday) between two dates. It can
also exclude a specified list of holidays from the calculated number of
days. Closely related to NETWORKDAYS is the WORKDAYS function that allows
you to add a number of weekdays to a given date.

Both are documented in the online help files.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Thanks a bunch it works like a charm.

How would you go about excluding holidays?
I am from Canada.

BW
 
To exclude holidays from the calculation, you must provide a list of
holidays -- Excel does not have its own list of holidays. Enter your list
of holidays in some range, say B1:B10, and pass that range to the function.
E.g.,

=NETWORKDAYS(A1,TODAY(),B1:B10)

will return the number of working days between the date in A1 and today,
excluding weekends and dates listed in B1:B10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
You can also put in the actual dates in the formula =NETWORKDAYS(C2,D2,{"1/1/2003","4/18/2003","5/26/2003","7/4/2003","9/1/2003","11/27/2003","11/28/2003","12/24/2003","12/25/2003","12/31/2003"}). Also, be aware that if your two dates that you want the difference between are the same date, then the formula as I have it here will return a 1. Ex. NETWORKDAYS will return a 1 when comparing 11/06/2003 to 11/06/2003 and a 2 if the dates are 11/06/2003 and 11/07/2003, etc. For the analysis I use this function for I want the same day to appear as 0, so I just put a -1 at the end of the formula.
 
Back
Top