H
HELP JOHNNY PLEASE
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!
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!