Sorting Dates

yobba

New Member
Joined
May 7, 2002
Messages
5
I have a list of dates in excel listed as 01/Nov/1986, 01/Feb/1996 etc.

I wish to sort the dates into order by the parameter of month first then by the day and then by year.

Is this possible?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
On 2002-05-08 08:36, yobba wrote:
I have a list of dates in excel listed as 01/Nov/1986, 01/Feb/1996 etc.

I wish to sort the dates into order by the parameter of month first then by the day and then by year.

Is this possible?

Are 01/Nov/1986, 01/Feb/1996 formatted date values or text representations of date values (e.g., "01/Nov/1986")?
 
Upvote 0
The dates are I believe text representations.

I've type the date as 01/11/1986 and it appears as 01-Nov-1986.
 
Upvote 0
On 2002-05-09 04:24, yobba wrote:
The dates are I believe text representations.

I've type the date as 01/11/1986 and it appears as 01-Nov-1986.

No, then they would be date values...

If your 1st date value is in cell A2 enter the formula...

=TEXT(A2,"mmddyyyy")

...into B2 and copy down, and then sort on these values.
This message was edited by Mark W. on 2002-05-09 09:06
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top