How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?

[Guest]

 

[Gord Dibben]

Enter 1/1/2006 in A1

In A2 enter =A1+7

Drag/copy down.


Gord Dibben MS Excel MVP