Date Sorting Problem

kilroyscarnival · #1 03-14-2022, 01:51 PM

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

PomDave · #2 03-14-2022, 02:53 PM

Ah, but that's where my problem lies. If you have only the year, say 2019, that's what the number is whereas March 10th 2019 has a numerical number of 43534.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula For Sorting In Order Date Wise	suniltko	Excel	5	05-15-2018 09:18 PM
Sorting Problem	RonLEngle	Excel Programming	8	12-19-2017 01:15 PM
Sorting problem in Excel	nrsmd	Excel	2	10-08-2017 11:54 AM
Problem sorting names alphabetically?	mikehende	Excel	12	09-12-2012 12:00 PM
sorting problem	gsrikanth	Excel	4	02-16-2012 12:30 AM