For example, if this week is March Week 3 Wednesday I want to be able to look at last year (2012) and find March Week 2 with the same number of days that in this year March Week 2 through current date.

In my file now, i have weekends as ONE Day and Monday is 1, Tuesday is 2, and so on. So i want it lookup using the following:

2012 - Week 2 - Wednesday so it should sum 2012 based on what number of days is currently in 2013 Week 3. Currently i am using a sumproduct formula. I am willing to change it.

On one tab i have the date information like this: 3/17/2013 March Week 3 Sunday

In another tab i have the data like this:

Day of Week Year Week&Month Sum
1 2012 201203Week 21 $16,126
2 2012 201203Week 22 $51,668
3 2012 201203Week 23 $67,970
4 2012 201203Week 24 $52,796
5 2012 201203Week 25 $74,394
6 2012 201203Week 26 $49,667

Since in 2013 3/13/2013 is a wednesday i want to sum <=4 but since last year 3/13 was a Tuesday its missing a day.

How can i fix this?