Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello! I'm running across a problem with calculations -- i'm hoping i can
get a little help here. Some staff are not able to view my NETWORKDAYS calculations due to excel 2002. It would be useless to have all 50+ staff perform add-ins. Any thoughts? Also, I used another formula which came up with more days? Maybe due to 30 or 31 calendar days? Here's an example of my formulas: start (b1) = 09/01/09 end (c1) = 09/30/09 =NETWORKDAYS(B1,C1,B45:B56) This comes out to 21 days =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,B1):INDEX(A:A,C1)),2)<6))--(ISNA(MATCH(ROW(INDIRECT(B1&":"&C1)),B45:B56,0))) This comes out to 22 days Help is greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
NETWORKDAYS #NAME? | Excel Discussion (Misc queries) | |||
networkdays | Excel Worksheet Functions | |||
NETWORKDAYS = 0 | Excel Discussion (Misc queries) | |||
Networkdays | Excel Worksheet Functions |