Date every sunday in month

[Pcasto]

Need a formula showing each Sunday in a given month
for example if A1 has 1/1/2011
A2 should show first Sunday = 1/2/2011
B2 2nd Sunday= 1/9/2011
C2 3rd Sunday= 1/16/2011
D2 4th Sunday= 1/23/11
E2- 5th Sunday = 1/30/11- if that month doesnt have 5 Sundays leave blank
Thx PC

 

[shg]

In A2, =A1-WEEKDAY(A1)+8

In B2 and across, =IF(MONTH(A2+7)=MONTH(A2), A2+7, "")

 

[Pcasto]

it works!! Thank you so much