AVERAGE Based on NETWORKDAYS

[surkdidat]

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!

 

[jdellasala]

Two suggestions. First, if you can't mess with the Master, make a copy of it in a new file or if it changes regularly pull it in to a new file with Power Query.

If you still have questions, post a sample using XL2BB.

Also, I suggest NETWORKDAYS.INTL where you can weekends and even create custom workdays rather than NETWORKDAYS where Weekends are loccked.