Lot of US-built tools use this format and it is very annoying. From Photoshop to Googlesheets to WhatsApp, Month always comes first. I tried for around 15 mins to change to date-first format in Google Sheets and failed.
Changing locale works fine for this in gdocs.
Same issue for me. Tried mm dd yyyy - still didn’t work.
Edit: I was trying to add 2022 as the year, which didn’t work. Changing that made it work.
Well this happened to me. You would have inputted date in the month field. The format is MMDDYYYY.