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

  • Thread starter Thread starter Guest
  • Start date Start date
Enter 1/1/2006 in A1

In A2 enter =A1+7

Drag/copy down.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amazon are rubbish 14
Sum amount of days in another coloumn 8
how do I add a future autodate 2
How do I insert autodates into an Excel spreadsheet? 1
Access Access 2010 - Date()-1 and times in query 0
Would like an explanation of a formula: 4
Add the monthly range in each row using the actual start and end d 4
how do I get autodate to stay the date it was saved 3

Back
Top