Hi,

Sunday of first week of 2009 : Sun 2010-01-03
I meant: Sunday of first week of 2010

If you don't care about weeks and only want the WW occurence of D (d=1 for Sun
and 7 for Sat) within the year YY (10056) : fifth Friday of Year 2010 : Fri
2010-01-29

=DATE(INT(A1/1000)+2000,1,1)-WEEKDAY(DATE(INT(A1/1000)+2000,1,
1-MOD(A1,10)))+7*MOD(INT(A1/10),100)

Regards,

Daniel M.