creating dates in excel

  Nos Bigkin 13:34 26 Mar 08
Locked

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

Nos

  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.

Nos

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…