Hey guys,

I'm sorry, I'm new to this, so I apologize if this has been answered or I'm not following correct protocol. I'm having trouble with calculating an average over the last 30 days, and through everything I've been trying to find via googling, I can't seem to get an answer I understand. Basically, I have an excel sheet with rows of data, and columns with the dates which I populate every day. To throw another wrench into this, I only take weekdays into consideration, so it would have to be the last 30 populated columns. I've got the average in general, but I would like to see that figure compared more recent data, which I can't seem to find. So as an example, here's I simplified version of what I see, along with what I'd like to see:

Column A B C AD AE AF AG BS BT

Average Last 30 day Avg 11/1/2013 11/4/2013 11/5/2013 11/6/2013.....12/30/2013 12/31/2013
Tickets 10.5 ??? 10 12 11 9 12 8


Any help with this would be greatly appreciated!!!