If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
networkdays alternative
I have several people that are not familiar with the Analysis Toolpak, is
there a work around for the networkdays function? I just have two dates in B33 (start date) & B34 (end date), so currently my formula is =NETWORKDAYS(B33, B34). Is there a way to acheive the same result without using the networkdays function? Thanks in advance, ~Gabe |
#2
|
|||
|
|||
networkdays alternative
Try one of these...
If you need to account for holidays... =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B33&":"&B34)),2)6),--(ISNA(MATCH(ROW(INDIRECT(B33&":"&B34)),C2:C10,0))) ) C2:C10 = list of holiday dates to be excluded. If you don't need to account for holidays... =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B33&":"&B34)),2)6)) -- Biff Microsoft Excel MVP "Gabe" wrote in message ... I have several people that are not familiar with the Analysis Toolpak, is there a work around for the networkdays function? I just have two dates in B33 (start date) & B34 (end date), so currently my formula is =NETWORKDAYS(B33, B34). Is there a way to acheive the same result without using the networkdays function? Thanks in advance, ~Gabe |
#3
|
|||
|
|||
networkdays alternative
I have formulas at
http://www.cpearson.com/excel/betternetworkdays.aspx that can be used in place of NETWORKDAYS. They have the advantage that you can specify any number of days of the week to exclude, whereas NETWORKDAYS has Saturday and Sunday hard-coded into the function. There are two versions of the formula on the page: one that supports a list of holidays and a second, simpler, formula that can be used if you don't need to account for holidays. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Wed, 19 May 2010 09:21:01 -0700, Gabe wrote: I have several people that are not familiar with the Analysis Toolpak, is there a work around for the networkdays function? I just have two dates in B33 (start date) & B34 (end date), so currently my formula is =NETWORKDAYS(B33, B34). Is there a way to acheive the same result without using the networkdays function? Thanks in advance, ~Gabe |
Thread Tools | |
Display Modes | |
|
|