Forum Discussion
Excel Date format: I am unable to sort excel table by date
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 |
Hijusticemehta,
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.
