Find and replace dates

Hi, I am having problems finding and replacing dates..
I hit Ctrl H and enter the date to find then go to options to set the format and still the date couldn't be found, is there another way??

Here's a find and replace macro, the main problem is probable the formatting in the find. in find and replace form hit the options button and select the format you are looking for, anyway here is the macro,

Please Login or Register  to view this content.

This code searches for the value in range A1 and its format, then replaces it with the value in B1

Cool,
Works just as you say