creating dates in excel

  Nos Bigkin 13:34 26 Mar 2008

Probably a simple solution to a fairly simple question but it's had me stumped for ages.

In the first column i typed in a date (26-03-08)
what i then want to do is drag this date down and for it to increase in value by weeks ie 02-04-08, 09-04-08 etc. Can it be done, or have i got to go through and type it all out (which would have been quicker now with the time i've spent mucking around).

Many thanks


  I am Spartacus 13:45 26 Mar 2008

Providing the column is formatted as Date then enter the first two dates, select both cells and drag down.

  Nos Bigkin 13:52 26 Mar 2008

Spartacus, thanks for your quick response, but how spooky is this, just prior to your response i happened to work it out my self so was just about to reply to my own question.
Once again, thanks.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?