Quote:
Originally Posted by PomDave
Hi All,
Now I don't think that this is possible, but if in doubt ask the experts.
I have a list that I want to sort either of two ways, one is by date and the other is alphabetical. The alpha works just fine, but when it comes to the dates I have problems, which is the part that I don't think is possible.
As you can see, the date can be dd/mmm/yy - mmm/yy - yyyy, and this is where the issue is.
Any ideas?
Best Rgds,
Dave R.
|
Dave,
Unless you're storing that date as text, all dates in Excel have an underlying numerical value. For example March 10th, 2019 in your first line, I'm presuming, is 43534. And even if you changed the cell's number formatting to display that as 19-Mar-2019, it's still that numerical value. So, yes, you should absolutely be able to sort on the dates. I just typed in three cells formatted American style, m/d/yy, and then dd-mmm-yyyy, and sorted them.
1/2/2022
11-Jan-2022
1/23/2022
14-Feb-2022
2/15/2022
01-Mar-2022