Formula to Average Throughput for Workdays Only - Omit weekends, holidays and current date

Good Day Folks,

I'm trying to average throughput data (Ins, Outs, Variance) for work days only. I need a formula that omits weekends, other non-workdays as listed, and the current date. The s/s is dynamic in that the last cell in col A contains

Formula:

Please Login or Register  to view this content.

so the weekends/non-workdays move up the column as days go by.

Appreciate any help,

Steve N.

This revised attachment shows it better - formulas in the desired results cells show what I'm trying to get. Thank you!

I'll give that a shot. This is part of a much larger s/s that feeds a report so there are a few limitations. I was thinking a formula would be much cleaner and not bloat the file...

Your work day/pivot table suggestion gave me an idea...

Since the Ins and Outs are so low on weekends/off days , I decided to total the entire month and divide by the number of 'Networkdays'. The results are within 1 unit or less. Close enough for this calculation...

Thank you for the help.