Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sorting by date
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sorting by date
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time and Date stamp - Pivot Chart | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
sorting data by date | Excel Worksheet Functions | |||
Sorting data by date | Excel Worksheet Functions |