Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date sort problem
I have grouped my date fields by Yr, Mnth, date. Everything looks good
at the onset. However after a few days the date field sorts chronologicly by date but breaks in the middle and starts over again. It has Jan 10-31 at the top. It then goes to Feb 10 - 29 and then March 10, etc. Half way through the list it then shows <03/14/2005 and then shows Jan 1-9, Feb 1-9 and so on. e gads. any way to keep the days listed Jan 1-31, etc? dl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date sort problem
"Denhamlee" wrote: I have grouped my date fields by Yr, Mnth, date. Everything looks good at the onset. However after a few days the date field sorts chronologicly by date but breaks in the middle and starts over again. It has Jan 10-31 at the top. It then goes to Feb 10 - 29 and then March 10, etc. Half way through the list it then shows <03/14/2005 and then shows Jan 1-9, Feb 1-9 and so on. e gads. any way to keep the days listed Jan 1-31, etc? dl No matter how they may appear in your spreadsheet, Excel stores all dates as a serial number equal to the number of days since a January 1, 1900. So when you are sorting dates, you are really just sorting a bunch of large numbers. If your dates do not sort correctly, it is usually because the value that "breaks" the sequence is not really the date it appears to be. So check very carefully at the point where things go bad. Make sure the cell is formatted as a date (any display format). Choose a display format that includes a 4-digit year if only to verify the data you are working with. With no other information to work with, that is all I can suggest now. B+ HALinNY |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date sort problem
Are you sure you've got dates and not text?
You can try adding helper columns =YEAR(A1) =MONTH(A1) and =DAY(A1). These will let you see whether the "dates" are what you think they are, and you could sort by those columns, but if you've got real dates they should sort OK. Also, make sure that you select the entire range before you sort. -- David Biddulph "Denhamlee" wrote in message oups.com... I have grouped my date fields by Yr, Mnth, date. Everything looks good at the onset. However after a few days the date field sorts chronologicly by date but breaks in the middle and starts over again. It has Jan 10-31 at the top. It then goes to Feb 10 - 29 and then March 10, etc. Half way through the list it then shows <03/14/2005 and then shows Jan 1-9, Feb 1-9 and so on. e gads. any way to keep the days listed Jan 1-31, etc? dl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
Date Format problem | Excel Discussion (Misc queries) | |||
Date is being changed to a number (problem) | Excel Discussion (Misc queries) | |||
date format problem | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions |