Averages - Day of the Week, Week, Month

**njexpress9** · 03-05-2009, 04:27 PM

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

**DonkeyOte** · 03-06-2009, 04:40 AM

Your sample file is not overly clear as you don't really stipulate what governs Week etc... the attached is an example meant to illustrate how by adding some additional formulae you can avoid the need for Array formulae... we don't know the volume of calcs you're looking to perform in reality... I suspect quite a few so I'm not convinced that an array approach would be wise.

With the additional columns (C:F) you could also think about having separate Pivot Tables for each report (weekday, week, month etc) displaying as Avg with Public Holiday set as a Page Field (set to 0)... this may be the best approach if you have lots of calcs to perform.