Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting by Date
Hello
I often work with a spreadsheet in which two of the columns are labelled Start Date and End Date respectively. The spreadsheet has about 3000 rows of data and is replaced with a new spreadsheet every fortnight. My problem is that when I try to sort the rows by one of these "date" colums I end up getting results that seem only to be sorted by day and then month, but not the year. For instance, by sorting the spreadsheet in ascending order by Start Date, I get the following result for the first ten records: 1/01/2007 1/01/2007 1/02/2007 1/02/2007 1/02/2007 1/03/2007 1/04/2007 1/05/2006 1/06/2006 1/06/2007 As you can see, it is clearly sorting by day and month, but not year. I have ensured the cells are in date format and have even tried using a couple of custom formats (d-mm-yyyy and dd-mm-yyyy), but the result is the same. I have also checked the date settings in the Operating System and made sure they were set to Australian formatting. So where to now? I have read about sort orders in the Help files, but don't seem to have made sense of all that. Surely I should be able to sort by date, including the year? Or do I have to try and create some sort of custom sort order? And, if so, how do I do this? Your help would be greatly appreciated! Thanks, Joe. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by Date, And SUM | Excel Discussion (Misc queries) | |||
Sorting by date | Excel Discussion (Misc queries) | |||
Date Sorting | Excel Worksheet Functions | |||
sorting by date | Excel Worksheet Functions | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) |