date formula

[Peter McCaul]

Hello,

In cell A3, I have today's date (March 18, 2007). I would like to copy that
cell down maybe 100 times. I would like each cell to be updated by 1 day.
I appreciate any help I receive. Thanks.

 

[Tommy]

Click on the cell, then click on the small dot on the bottom right corner of
the cell. Now drag the cell down.
Make sure that the column is formatted to 'date'.

 

[Dave Peterson]

You could put this in A4
=a3+1
(format it nicely)
And drag down another 99 rows.