"Daddy Rich" wrote:
Hi, i need column A of a new document to show a list of dates running 7 days
apart. Ie, If A1 showed 24/04/05 then A2 should show 01/05/05, A3 should show
08/05/05 etc.
Assuming A1 contains a real date recognize by Excel
In A2: =IF(A$1="","",A$1+ROWS($1:1)*7)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---