Sorting Dates

[yobba]

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?

[Brian from Maui]

Yobba,

Format your dates to mm/dd/yy, then sort

[Mark W.]

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")?

[yobba]

The dates are I believe text representations.

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

[Mark W.]

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 ]