Tue, 15 May 2007 21:22:01 -0700 from Twishlist
:
I want to create a running sheet of dates down the page, each date is 7 days
ahead of the former. Also, each date will be separated by 5 rows before the
next date isdisplayed.
I can find date formulas that calculate number of days inbetween given
dates, but can't find a simple 'add 7 to the last date' function. It's
probably simple, but I would welcome some guidance.

Put your first date in A1. In A6 (5 rows later) put =7+A1. Format it
as a date. Then copy cell A6 to A11, A16, A21, etc for as many weeks
as you need.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/