Net Work Days
Greetings,
I have one sheet which contains a status, date received, and a date
completed.
I would like to be able to calculate the average number of work days between
date received and date completed where the status is equal to "closed".
I have figured out a not so slick way by adding another column to my sheet
and calling the networkdays function on every row.
I'd like a more elegant solution where I can look across the entire range
and calculate the average number of networkdays where the status is equal to
"Closed".
I tried average(networkdays(received range:closed range)) for starters but
the networkdays function doesn't want to take a range of values......
Help/Suggestions welcome....
|