Formula For Sundays In Annual Calender

[travelersway]

I'd like to arrange a formula where I can enter the year (example: 2007) in cell A1 and I could get the date for each sunday (mm/dd/yyyy) of the year and have them entered in locations B1 through B52.

Any help is appreciated.
Travelersway

[Carim]

Hi,

You would have to test the 365 days with weekday(eachdate)=1 ...

HTH
Carim

[VBA Noob]

Hi,

Enter in A1 a the date 01/01/07 and custom format as YYYY

then in B1 enter

=A1+(WEEKDAY(A1)>=1)*7-WEEKDAY(A1)+1

Then in B2 enter

=B1+7

Custom Format Col B as mm/dd/yyyy

PS Change the 1 to 2 for first Monday etc

VBA Noob

[daddylonglegs]

If you have the 1st jan date in A1 then you only need this formula in B1

=A1+7-WEEKDAY(A1-1)

or with just the year in A1

=DATE(A1,1,8-WEEKDAY(DATE(A1,1,0)))