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>
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.