Hi
I am trying to work out the average number of days a certain workstream has been open (workdays)
So based on Workstream AAA I want to return 4.5 days (6+3)/2
I am trying to work out the average number of days a certain workstream has been open (workdays)
So based on Workstream AAA I want to return 4.5 days (6+3)/2
Column H (Date Received) | Column K (Workstream) | (Column for info only) | (Column for info only 2) |
20/06 | AAA | (open 6 days) 20 21 22 23 26 27 | 6 |
26/06 | BBB | (open 2 days) 26 27 | 2 |
23/06 | AAA | (open 3 days) 23 26 27 | 3 |