It wasted few days, hitting my head at the wall.
My mistake ….

I trusted that Google Sheets function called GoogleTranslate is working as it is expected.

Which is not

You just hate when that happens.
We all know that Google is still a child in worksheet world, comparing to Microsoft, they are kids, but I wouldn’t expect a large company like Google to mess up a formula that made it available to public. not good Google, not good.

Again, googletranslate that is supposed to change the date from Europe format into US format is not working, do not build on that