Add one year to dates
 

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.

Add one year to dates
 

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.

Add one year to dates
 

That was too easy...isn't there a more complicated solution? ;)

Thank you

"Ron Coderre" wrote:

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.

Add one year to dates
 

Of course, Lee!.....there's ALWAYS a more complicated solution. In fact, I've
worked with several people who had a natural talent for finding unduly
complicated solutions. <vbg

....and thanks for the feedback...I'm glad I could help.
***********
Regards,
Ron

XL2002, WinXP


"Lee D" wrote:

That was too easy...isn't there a more complicated solution? ;)

Thank you

"Ron Coderre" wrote:

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.