Excel 2010 auto adding 7 days to column

  FatboySlim71 11:41 09 Dec 2010

I have Microsoft Excel 2010 and I have Windows Vista.

I am wanting to create a Spreadsheet which will allow me to keep a record of my weight. I check my weight every 7 days.

I was wanting to know how I could create a Spreadsheet that would have a column for the date and another column where I enter the weight.

I would like Excel to automatically enter the date, in the date column and automatically advance the date value by 7 days for the next entry.

Does anyone know if it is possible to do what I am wanting, and if so, could anyone give me instructions on how to do it please.

Thanks in advance.

  VoG II 11:44 09 Dec 2010

Enter a date in A2.

In A3 enter


and fill down as far as needed.

  FatboySlim71 21:42 09 Dec 2010

Thanks VoG™, I enter a date in column A2. I then enter =A2+7 into column A3, but from there how do I get Excel to go down the column/page automatically inserting a date 7 days on from the previous column.

I've included a link to a screen shot to show how far I have got.

<a href="click here" title="2010-12-09_213914 by PC Bloke, on Flickr"><img src="click here" width="697" height="837" alt="2010-12-09_213914" /></a>

  FatboySlim71 21:44 09 Dec 2010

If that link doesnt work try these.

click here

[url=click here][img]click here[/img][/url]
[url=click here]2010-12-09_213914[/url] by [url=click here]PC Bloke[/url], on Flickr

  QuizMan 21:52 09 Dec 2010

I have not used your links, but the following will work:
Select cell A3 and move the cursor to the bottom right hand corner of it. The cursor should change to a small black cross. Click and hold down the mouse button on that corner and drag the cursor downwards for as far as you want. It will add 7 days to each cell.

  QuizMan 21:56 09 Dec 2010

I should have mentioned that it also works if you want to drag the cursor across rather than down.

  FatboySlim71 22:10 09 Dec 2010

Thanks QuizMan.

I have done what you mentioned, but all I get when I do it is the same date entered in the column going down the screen/page.

  KremmenUK 09:15 10 Dec 2010

I suspect what you've done is drag the top date down which doesn't contain the formula.

Once you have the formula in say A3 then drag that cell down and it will work.

  FatboySlim71 15:46 10 Dec 2010

Thanks for the help. So which columns (A1 A2 A3) should I enter the first date in?

Also which column should I enter the formula in?

Thanks again for the help.

  VoG II 15:52 10 Dec 2010

In A2 enter a date.

In A3 enter the formula


Click in A3 and hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as you want. release the mouse button.

  FatboySlim71 18:49 10 Dec 2010


I done what you mentioned above. In A3 the date is 7 days on from the date in A2, but from A4 and beyond the date remains the same as the date in A3.

Thanks again for the help its much appreciated.

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

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique