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

Hi,

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:

TEXT(DAY([Date])&"/"&MONTH([Date])&"/"&YEAR([Date]))

and use this one to display.

Hope it works until you find a better solution.

1 Like
3 Likes