Forum Discussion
How to sort data by date format
Hi - I'm using PC/Windows 10, and Excel version 2018 My excel data looks like this. I have 1500 rows. Date of hire Gender Race/Ethnicity Level Promotion Date new level term date type of...
how can you tell which date is formatted which if the date is 12 or less and the month is 12 or less? i.e 12/12/2007? or 9/12/2007? or 12/9/2007? How can you tell which number is the day and which number is the month and how do you decide how to sort them? by month? or by day?