What's Wrong with this formula - ?

[Frank Bacchus]

Sheet1 has my data. I am trying to use multiple ifs to calculate time id the status is open or closed, Here is the formula I use to check the condition of "Open"

=IF(E2="Open",NETWORKDAYS(C2,TODAY(), N2:N5)) - works like a charm

Here is the formula I am trying to use for "Close"

=IF(E2="Open",NETWORKDAYS(C2,TODAY(), N2:N5, IF(E2="Close",NETWORKDAYS(C2,D2, N2:N5)))

Does not work like a charm - am I missing something

frank

 

[Hui]

you're missing a Bracket ) in the middle

try H2:
=IF(E2="Open",NETWORKDAYS(C2,TODAY(), $N$2:$N$5), IF(E2="Close",NETWORKDAYS(C2,D2, $N$2:$N$5),"Check Status"))

Copy down

 

[Frank Bacchus]

Sheet1 has my data. I am trying to use multiple ifs to calculate time id the status is open or closed, Here is the formula I use to check the condition of "Open"

=IF(E2="Open",NETWORKDAYS(C2,TODAY(), N2:N5)) - works like a charm

Here is the formula I am trying to use for "Close"

=IF(E2="Open",NETWORKDAYS(C2,TODAY(), N2:N5, IF(E2="Close",NETWORKDAYS(C2,D2, N2:N5)))

Does not work like a charm - am I missing something

frank

Thanks Hui:

I missed that. Thanks. How would you suggest I calculate the average number of days by Effort Level in a Pivot table. In other words, now that I have the number of days issues are opened and the number of days it took to close, I would like to produce a chart showing
(1) the number of open and closed issues
(2) the number of issue for each individual, across effort level
(3) the average number of days that the issue stays open across effort level
(4) the average number of days it takes, over all, to close issues across effort level
(5) and the average number of days it take each individual to close issues across effort level

Any suggestions would be gladly appreciated

frank