Network Days Count accuracy

[Ann]

I'm using this formula to count scheduling accuracy by workdays. When the
team delivers on the scheduled date, the result is "1", so I've added "-1" at
the end of the formula. I have a bigger problem, which is related. For this
criteria: target date - 09/01/05 and delivery date - 09/03/05 the result is
"-1", but should be "-2".

Any ideas on what's wrong with this formula?

=NETWORKDAYS(IF(COUNT(L15:O15),MAX(L15:O15),P15),P15)-1

 

[Ron Rosenfeld]

I'm using this formula to count scheduling accuracy by workdays. When the
team delivers on the scheduled date, the result is "1", so I've added "-1" at
the end of the formula. I have a bigger problem, which is related. For this
criteria: target date - 09/01/05 and delivery date - 09/03/05 the result is
"-1", but should be "-2".

Any ideas on what's wrong with this formula?

=NETWORKDAYS(IF(COUNT(L15:O15),MAX(L15:O15),P15),P15)-1

I'm not sure about your formula, but consider this:

NETWORKDAYS counts both the starting and ending date (assuming they are
workdays).

In your example, 1 Sep 05 is a Thursday; 3 Sep 05 is a Saturday. So the count
of workdays would be 2 (Thursday and Friday).
--ron

 

[Tom Ogilvy]

The only way I could see getting -1 out of that formula is if you were doing
essentially Networkdays(P15,P15)

that would return 0 and your formula would subtract 1 from that.

in the formula bar, highlight

IF(COUNT(L15:O15),MAX(L15:O15),P15)

and hit F9 to see what that portion of your formula is returning. Then hit
esc to restore the formula.

 

[Tom Ogilvy]

or that the days addressed in the formula include no workdays.