sorting by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet with
date amount description
12.12.06 5.00 PLUMBER
04.02.01 50.00 ELECTRICIAN
ETC
How can I sort into date order.

When I try I get all the 2001, 2006, 2005 together but not 2001, 2002,
2003,2004

Cananyone help please
 
Is 12.12.06 text or a date value? In a blank cell, enter ISTEXT(A1) where A1
is a cell reference to this date. True means it is text and 03.01.07 will
come before 12.12.06.

You can set up a helper cell, enter
=DATE(RIGHT(A1,2),LEFT(A1,2), MID(A1,4,2))
where I'm assuming 12.12.06 is month/day/year. The parameters for DATE are
year, month, day - so make sure the Right, Left, and Mid functions are in the
correct order. You should get a date that is a numeric value. Copy the
formula down and sort using this new column.
 
Thanks for your help. I finally woked out what was wrong date was in wrong
format S/be 12/12/06 not 12.12.06
 
Back
Top