Re: Happens in Google sheets as well.
All dates on sheets I create are now entered in 'ISO 8641 Date' format for those very reasons.
Sometimes somebody will comment - "What is that value?" to which the answer is "A date, formatted unambiguously in compliance with an internationally recognised standard". People have complained that it is difficult to understand, to which the response is along the lines of "Well that's not a problem with the data or the system..."
Long week - must be about time to go to the brewery!