What better way to work with Dates?

[jqfranco]

Good Morning
I've searched a lot and haven't found the best way to work the dates in the cells of the sheets and in the column of the table.

Personally, I put the table's cell and column, all in Date Short, but there are those who put everything in Text mode.

In my case, I put everything in Short Date, but then I have a battle to keep everything in dd/mm/yyyy, because when I look at the table, some dates are in mm/dd/yyyy format.

The file is accessed by several users over the internet.

So I ask, what is the best way to solve this problem?
Thank you for your help

 

[RoryA]

You should always use actual dates since they are stored as numbers and not open to interpretation. Storing as text is generally a recipe for disaster because any interpretation will be down to the users regional settings.