View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?

Enter 1/1/2006 in A1

In A2 enter =A1+7

Drag/copy down.


Gord Dibben MS Excel MVP


On Thu, 12 Jan 2006 11:36:03 -0800, "tlk1214"
wrote: