Datevalue not working when " / / " appears

[Burt_100]

Hi
I am importing data from an external source which is importing it as text, I have been using the datevalue formula below and it works great in column A however in columns G,J,K I am getting a type mismatch error due to the suspected " / / " appearing when a date is not available, Any ideas how I can get around this?

Please Login or Register  to view this content.

[davesexcel]

Possibly,

Please Login or Register  to view this content.

[Burt_100]

code works great the only problem that I have now is that it is mixing up the date and making the day the month and vice versa, is there a way to format this?

[davesexcel]

Please Login or Register  to view this content.