Formula to find first weekday in month

Hi ,

I need help with something

I have a worksheet, that compare the sales of last year with the sales of current year,

but we want compare week day by weekday, not month day by month day, (example: i want compare the first sunday of 2013 with first sunday of 2014, not day 06/02/2013 by 06/02/2014)

In attachment I send a image from my worksheet,

in 2014 the first day of June is in a Sunday,
So the sales in column 06/01/2014 must be the first sunday in June/2013, that be 06/02/2013

But the last day will not match with current year,

I need a formula that search the first equal weekday in the june/2013 then transpose the sales to the equal weekday in 2014

Example:
First Sunday in 2013 (06/02) = First Sunday in 2014 (06/01)

Third Saturday in 2013(06/15) = Third Saturday in 2014(06/21)

Because if I use a simple formula with "=C5" for example, the first saturday of 2014 will be compared with second saturday of 2013


Someone could Help Me?3


shhet.jpg