Macro to change text date into normal date

Hi All,

I need some help on a macro. I have a file as attached and the problem is the dates in the below columns are all in text format and I need it to be in date format instead.
I have a macro but whenever there is blank cells it stops the macro from running. Is there any better vba code I can use?

The macro code which I am using is in Sheet2

Columns that needs to be changed to Dates - Column F, I, S, T, AF, AK, AL, AO, AZ, BA
(Also highlighted those columns in Yellow in Sheet 1)

Kind Regards,
MArk.

Not coded but you can use text to columns on each to enter the cell values as you require.

See if this is what you are after.

Please Login or Register  to view this content.

Originally Posted by PFDave

Not coded but you can use text to columns on each to enter the cell values as you require.

Hi PFDave,

Yes that works but Jindon provided a macro as well which wors. Thanks for your help sir. :-)

Kind Regards,
MArk.

Originally Posted by jindon

See if this is what you are after.

Please Login or Register  to view this content.

Hello Jindon,

This works perfect. Many thanks Sir.

Kind Regards,
MArk.

Originally Posted by AlphaFrog

Try this...

Please Login or Register  to view this content.

Hi AlphaFrog,

This works as well. Many thanks.

Kind Regards,
MArk.

Originally Posted by kev_

or this:

Please Login or Register  to view this content.

Hi Kev_,

This works for me as well.
Thanks.

Kind Regards,
MArk.