Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / April 2008

Tip: Looking for answers? Try searching our database.

Sorting Dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pammy - 24 Apr 2008 20:22 GMT
When I sort dates, they are sorting in order.  The format is a date format
03/01/05.
When I choose assending order, they start out ok, but then get mixed up:
3/01/05 - 03/06/05, 03/02/05, and even the end 05/01/04,any idea?
Dave Peterson - 24 Apr 2008 20:43 GMT
Your dates aren't what you think they are.

They could be completely different:
05/01/04 could be May 1, 2004 or January 5, 2004 or January 4, 2005.

Or they could be plain old text (that look like dates).

I'd select that range and give it a nice unambiguous date format, like:
mmmm dd, yyyy

And see what your data shows.

The values that are text won't change--you'll still see 03/06/05.

ps.
If this is a single cell:  3/01/05 - 03/06/05
then it's not a date--it's a string and will sort in plain old alphanumeric
order.

If you want to sort in date order, you'd be better off by putting the start and
end dates in different columns--and use real dates.

> When I sort dates, they are sorting in order.  The format is a date format
> 03/01/05.
> When I choose assending order, they start out ok, but then get mixed up:
> 3/01/05 - 03/06/05, 03/02/05, and even the end 05/01/04,any idea?

Signature

Dave Peterson

David Biddulph - 24 Apr 2008 20:50 GMT
03/01/05 is an ambiguous format.  Format the cells as something unambiguous,
like dd mmm yyyy, and then you'll see what dates you are really dealing
with.
--
David Biddulph

> When I sort dates, they are sorting in order.  The format is a date format
> 03/01/05.
> When I choose assending order, they start out ok, but then get mixed up:
> 3/01/05 - 03/06/05, 03/02/05, and even the end 05/01/04,any idea?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.