Get all Sundays

[Rick]

Hello All,

what I want to do is put a year in A1 and return the first Sunday day date
in cell A2. The second Sunday day date in A3. The third Sunday day date in
A4 and so on. Then all I need to do is change the year and the cells will
reload to the correct day dates. Is this possible? I am trying to make a
Sunday school attendance book.

Dunnie

 

[Ron Rosenfeld]

Hello All,

what I want to do is put a year in A1 and return the first Sunday day date
in cell A2. The second Sunday day date in A3. The third Sunday day date in
A4 and so on. Then all I need to do is change the year and the cells will
reload to the correct day dates. Is this possible? I am trying to make a
Sunday school attendance book.

Dunnie

A2: =DATE(A1,1,8)-WEEKDAY(DATE(A1,1,7))
A3: =IF(YEAR(A2+7)=A$1,A2+7,"")

Fill down to A54.
--ron

 

[Guest]

Hi Rick,

If you put the actual date in Cell A1 as 1/1/2007 then you could do the
following.

In cell B1 =A1+7-WEEKDAY(A1,2)
In cell B2 =B1+7
Copy cell B2 down to produce entire year.

Tip: Did you know that you can custom format column B to show the day of the
week. Use ddd dd mmm yyyy to show date as Sun 07 Jan 2007.

Use this dddd dd mmmm yyyy to display without abbreviation like this:-
Sunday 07 January 2007


Regards,

OssieMac

 

[Guest]

Year in A1
In A2: =DATE($A$1,1,1)-MOD(DATE($A$1,1,1)-1,7)+7*ROWS($1:1)

copy down as far as needed

 

[Rick]

Thanks everyone,

Thats what I needed.