In my "Master List" tab, I have:
Column G - "Date received"
Column Q - "Date Completed"
Column I - "Workstream"
Column K - "Status" (Open, Complete, Rejected etc)
What I need is a formula please in my "Stats New" tab
In this tab I have:
Cell B2 "Week Start Date"
Cell B3 "Week End Date"
Column D "Workstream"
So, I need to return the average number of days (Networkdays) (Column A in Stats Sheet) for each workstream of how long every item in that week took to complete
Unfortunately, I cannot simply add columns to the "Master" sheet as this runs through another program, and may affect (and is locked down anyway)
Thanks!
Column G - "Date received"
Column Q - "Date Completed"
Column I - "Workstream"
Column K - "Status" (Open, Complete, Rejected etc)
What I need is a formula please in my "Stats New" tab
In this tab I have:
Cell B2 "Week Start Date"
Cell B3 "Week End Date"
Column D "Workstream"
So, I need to return the average number of days (Networkdays) (Column A in Stats Sheet) for each workstream of how long every item in that week took to complete
Unfortunately, I cannot simply add columns to the "Master" sheet as this runs through another program, and may affect (and is locked down anyway)
Thanks!