I have the opposite problem. Half the time no matter how much I change the formatting on the cells I can’t get a table to sort by date. It insists on alphabetical instead, so you’ve got 1/12/2024 ahead of 1/13/2023.
When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.
I still use the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.
YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.
I have the opposite problem. Half the time no matter how much I change the formatting on the cells I can’t get a table to sort by date. It insists on alphabetical instead, so you’ve got 1/12/2024 ahead of 1/13/2023.
The solution for that is using a sane format for dates.
When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.
I still use the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.
YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.
Yeah - I don’t get to determine what date format 3rd party reports are generated in before I import into excel.
But excel has formatting options specifically designed to address this that it just ignores half the time.