creating dates in excel

  Nos Bigkin 13:34 26 Mar 08

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 08

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 08

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac