NETWORKDAYS function

P

Peo Sjoblom

Yes, it is part of the ATP add-in (analysis toolpak), it comes with excel or
office,
but it has to be installed..
 
C

Chip Pearson

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 [email protected]
 
B

brianwa

Thanks a bunch it works like a charm.

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

BW
 
C

Chip Pearson

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 [email protected]
 
N

Nathan

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.
 
Top