Forum Discussion
Can't Sort Based On Date/Time
Hoping someone can help. I have a simple Excel data set where the first colum is the date (i.e. Dec 1 2023) and the second column is the time (i.e. 7:12 AM). I have been unable to sort the da...
Dates and times in Excel are numbers. Specifically they are the number of days measured from January 1st 1900 with fractions of a day representing the time of day. So, what looks like 'normal' dates
are actually
when formatted as general numbers. If your 'General' formatted dates still look like US formatted dates then they are text rather than numbers, and Excel will not recognise them as dates and will instead simply sort the so-called dates into alphabetical order.
If you are lucky, you may find that the function DATEVALUE will convert the dates held as text to numbers
