Shazam
02-16-2006, 02:20 PM
Need some with dates.
I have a worksheet that has dates but it starts off with
wk 02/13/2006
or
w 02/13/2006
or
week 02/13/2006
or
weeks 2/13/2006
and so on.
I recieve the worbook from the customer.
I have a simple macro that I recorded to a find and replace but the dates text is not always the same.
Is it possible a code that could recognize they are dates and convert them in true dates?
My sample workbook is below.
I have a worksheet that has dates but it starts off with
wk 02/13/2006
or
w 02/13/2006
or
week 02/13/2006
or
weeks 2/13/2006
and so on.
I recieve the worbook from the customer.
I have a simple macro that I recorded to a find and replace but the dates text is not always the same.
Is it possible a code that could recognize they are dates and convert them in true dates?
My sample workbook is below.