Average last 6 weeks and year before
 

Hi all,

Great forum and a lot of threads already helpt me out! Now, unfortunatley I got a little stuck with my excel sheet. Hope someone can help out!

I'm building a database with data about the amount of calls as of Januray 1st 2009 till the future. I'm looking for the average of the last 6 weeks and the same week we are in right now from last year (so, for example average of the last 6 Wednesdays and the 5th of Aug 2009, also Wednesday). I have the solution of the last 6 weeks (thanks to another thread), but not including last year)

Currently it looks like this and everyday I just copy-paste new data of the day befo
08:00 08:15 08:30
Sunday 8 August 2010 5 7 6
Saturday 7 August 2010 5 7 6
Friday 6 August 2010 5 7 6
Thursday 5 August 2010 5 7 6
Wednesday 4 August 2010 5 7 6
Tuesday 3 August 2010 5 7 6
Monday 2 August 2010 5 7 6
31

Below all the data, I'm now calculating for the last 6 weeks: =sumproduct(a1:a1258="Wednesday")*(B1:B1258=TODAY ()-42)*(D1:D1258))/6

Thanks in advanced for all your help!!!!

Nynke

If anybody also knows how to calculate the MAX and MIN for the same period, that would be great. Because now I only can extract the average.

Thanks,
Nynke

Doesn't anybody has an answer for the questions??? Please help!!!

THX,
Nynke