With the date in A1, you can put this formula in A2:

=A1+1

which will add one day on to the previous day. Copy this formula down
and you will have all your dates for the whole year. You only need to
change the date in A1 to have a knock-on effect on the other dates.

Hope this helps.

Pete

On Jan 18, 5:27*pm, Dick C wrote:
I am setting up a spreadsheet of investments. *The first column (A, row 1)
has Monday 01/21/2008, the next row (column A, row 2) is Tuesday 01/22/08 and
so forth through the end of the year (Wednesday 12/31/2008). *It takes a long
time to set all that up. *I'm now wondering if the dates can be automatically
changed - say from Monday 01/21 to Monday 01/19 and the years change from
2008 to 2009? *Can that be done without my having to input all the dates
again for next year? *Thanks for any help you can give?