Excel Date format: I am unable to sort excel table by date

Copper Contributor

I have selected Gujarati language and short date format 14/03/2012. but not able to sort. Please guide and help.

30-03-2023
30-04-2020
30-04-2023
30-06-2019
30-06-2023
30-06-2023
30-06-2024
30-10-2016
30-11-2018
30-11-2021
30-11-2022
31-01-2024
31-01-2025
31-07-2023
31-10-2010
31-10-2019
31-10-2021
31-10-2023
31-11-2022
31-12-2020
1 Reply

Hi@justicemehta

your data are not date values. Therefore, they are sorted like text. There are two clear indications for this.

Your dates are left-justified. If they were dates, they would be right-justified.

In addition, there would be an error in the penultimate line. There is no 31 November!

Format the cells as dates and copy the cells in again. Then it should work. If you format the cells as numbers, there should be numbers in the cells. Dates are simply numbers internally in Excel. For example, 23.3.2023 is 45015.