|Adding 364 to each date should give you the same day of the week in 2012 as you have in 2011. |
I tested it with the WEEKDAY function and it works for all dates except for New Years Day.
1/1/2011 + 364 = 12/31/2011 The day of the week is the same (7 = Saturday) but 364 days later is still 2011.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.