Excel Find and Replace for Dates

Hello,
I included a dummy wkbk, but I am trying to find a way for Excel's find and replace feature to change some cells formatted as dates from one year to the next year without having to manually re-enter the dates. I can't use the dragging method after putting in a formula because there is text after a certain number of cells that throws the formula off. I was able to use the find and replace feature to change the text dates but not the formatted formula dates. See workbook for better understanding. Thnx.

HP RodNuclear

Replace
Find what: /2010
Replace with: /2011

Replace All

Regards

you could just try adding 365 to them but thats not always the best thing(and leap years need to be considered), depends what you need to do just put 365 in a cell copy/paste special (over values in col A) "add"
or what TMshucks said lol

Replace method is the easiest.

However this should work in column B
In B1

Please Login or Register  to view this content.

Drag/Fill Down

This should add one year to dates, and your text strings.

@Martin: "or what TMshucks said lol" ???? ;-)

Works for me (and in the test workbook)

i added that as i was posting coz i thought it was the best solution and i couldnt see how i overlooked it!