Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

Get all Sundays

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Networkdays plus Sundays	Kurt Levitan	Excel Worksheet Functions	4	September 11th 06 07:53 PM
Number of sundays between two dates	Carianne72	Excel Worksheet Functions	4	August 9th 06 02:58 AM
# of Sundays in a year	lsmft	Excel Discussion (Misc queries)	18	April 27th 06 02:26 PM
No Sat & Sundays	lsmft	Excel Discussion (Misc queries)	5	April 12th 06 05:52 PM
calculation sundays between two dates	jeff thinkin	Excel Discussion (Misc queries)	3	September 15th 05 02:07 AM

All times are GMT +1. The time now is 10:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us