My VBA knowledge is fairly basic so I'm looking more for an answer
than help with developing the code.

I typically have data files with 1 data point per weekday that will
sometimes be 15 years long. I would like to have a macro that will
give me a series of monthly averages of the daily data for each month.
Obviously I can do it manually by entering the average function for
each month's daily data range, but going thru 15 years of daily data,
with a different number of weekdays in each month, to calculate a
monthly average for each is a pain. Any suggestions or help would be
greatly appreciated.

Thanks