Sorting dates

[AB]

I have date column set as: d/m/yyyy
when I do a sort its sorting by day, I want it sorted chronologically, how
can this be done?
eg heres what my sort ended up as: 12/8/1819, 13/2/1835,17/12/1813,19/5/1833

Thanks
Althea

 

[Frank Kabel]

Hi Althea
if you have only dates in this column just sort them. This sort
meachanism is Excel's default.

 

[Andy Wiggins]

1819? 1835? 1813? 1833?

Excel doesn't recognise dates before 01-January-1900

If these are the years in your dates then I would guess that your cells are
either formatted as text or you have input the dates as text. If this is the
case then the sort result you are getting is correct.

Here is a suggestion to sort your dates into order:
Split the dates into three "helper" columns: put the year value in one, the
month in the next and the day in the last, and then sort.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Bob Phillips]

Althea,

I think your problem may be due to entering dates before 1900, and Excel
does not support dates before 1900.

If you enter these backwards as text in a standard format, that is
yyyy/mm/dd, you can sort as text and get the results that you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[AB]

THanks for all the suggestions, hadn't considered the problem was the early
dates.
Bye
Althea