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.