Date sort problem

D

Denhamlee

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
 
D

David Biddulph

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.
 
Top