Thread: date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default date formula

"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
---