From your description I guess you want to increase each cell by one day?
If so, simple answer:
in A2 enter =A1+1 and copy down as far as you wish.
If you then want the dates to remain 'as is' then Copy - Paste Special -
Value (you may then need to format the cells to your date format) otherwise
if you subsequently change a date all those dates below will change!
Hope this is what you require?


"Cougtony" wrote:

Hi, Simple question. I have a spreadsheet with a list of dates in a colum and
I want it to automatically update as I copy. I.E. A1 cell has 9/5/2007 and i
want in A2 and as far as I copy and paste it to add to the correct date A2
9/6/2007, A3 9/7/2007 and so on