Try this:

Select the range containing the dates

From the Excel main menu:
<edit<replace
Find what: 2006
Replace with: 2007
Click the [Replace All] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lee D" wrote:

I would like to add one year to all dates in a spreadsheet (2006 to 2007.)
There are no dates in calculations.

Thank you in advance for any replies.