sorting by date
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.
"cantgetit" wrote:
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
|