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 |
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 |
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 |
All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com