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.
|