sort by date ?

  • Thread starter Thread starter RaY
  • Start date Start date
R

RaY

Hi.

I am trying to sort a column of dates in the dd/mm/yyyy date cell
format in order. Using the sort function it seems only to sort by
day then month and ignores year. What Iam getting is :

01/10/2008
01/11/2007
01/12/2008
02/01/2008

And what I need is:

01/11/2007
02/01/2008
01/10/2008
01/12/2008




Any ideas ? Thanks in advance.

Ray.
 
It sorts fine for me, your dates must be text.

Try selecting the column, then goto Data>Text To Columns, Next the first two
dialogs and on the third select Date from the option buttons.
 
Your cells are probably text, not dates. You can test with the ISTEXT()
function.
If so, do the following:
Copy an empty cell. Select your data. Paste Specoal, chack Add. Format the
cells as date.
 
Back
Top