Change date format

Hi, How can I change the format of the date? from month/day/year to Day/Month/year .

Thank you, currently I get the message Invalid Date


When I was using Excel, I wasn’t able to change it.
Now I use Google sheets and it was DD/MM/YYYY by default.

All I can suggest is to add a virtual column with the formula:


and use this one to display.

Hope it works until you find a better solution.

1 Like