Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
No. of days split into periods | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) | |||
Sumproduct help needed! | Excel Worksheet Functions |