Excel 2010 auto adding 7 days to column

  FatboySlim71 11:41 09 Dec 10
Locked
Answered

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 10

Enter a date in A2.

In A3 enter

=A2+7

and fill down as far as needed.

  FatboySlim71 21:42 09 Dec 10

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 10

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 10

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 10

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

  FatboySlim71 22:10 09 Dec 10

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 10

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 10

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 10

In A2 enter a date.

In A3 enter the formula

=A2+7

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 10

VoG™

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.

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

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

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…