I think the main problem is that your inputs aren't actually in the format you want, being in yyyy/dd/mm rather than yyyy/mm/dd. It would seem that Excel doesn't recognize yyyy/dd/mm as a format, and that's why you are getting the error. Note that in the rows where the text can be parsed as yyyy/mm/dd, Excel is converting the date part to ISO 8601 format.