The first formula I proposed can be used in all cases where strings need to be cleaned, while yours is specific to cleaning and converting to dates at the same time.
It also introduces the technique for converting dates ( when applicable) using the Text to Columns feature

IMO, using helper columns ( created by the first formula) is much more easy when it comes to finding errors and is easier to understand

In your ( excellent) solution errors would be harder to find
A nice article on cleaning "dirty" data