Since neither is a leap year, you just need to advance 365 days. So type 365
in some random cell and copy. Then select all your date cells and Edit
Paste Special, select the 'add' radio button and click OK.

"Lee D" wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee