I am trying to convert date from a column that is a text type, when i try to format directly by Google sheets format option, it only formats a few dates but others not, I have tried using DATEVALUE function but i get the following error: DATEVALUE parameter '26/05/2022' cannot be parsed to date/time.

I have no idea how to proceed with this date cleaning and correctly formatting, any help will very much appreciated.