Averages - Day of the Week, Week, Month

Hoping for some insight.

I have a ending balance worksheet and would like to calculate the averages by day of the week, work week and month.

Is there a way to exclude holidays?

Any help will be greatly appreciated.

Thanks,
njexpress9