LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Spin
 
Posts: n/a
Default Sort by date - just not getting it all the way there

Hi,

I am having a nightmare of a time trying to sort a date column in a
spreadsheet. The column is made up of dates as shown below and the dates
will sort in descending order all the way out to the year due to some kind
of limitation. Here is my column:

9/28/2005
9/28/2004
9/27/2005
9/27/2004
9/26/2005
9/26/2004

See what I mean??? I want it to look like this:

9/28/2005
9/27/2005
9/26/2005
9/28/2004
9/27/2004
9/26/2004

Thanks. :-)

--
Spin


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sort date in excel pusimani Excel Worksheet Functions 2 December 16th 05 04:57 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
How do I sort by date (not days, weeks, months) in Excel 2000? Tony Excel Discussion (Misc queries) 1 January 21st 05 03:28 PM
In Excel, why sort function fails when applied to a list of date? Excel heavy user Excel Discussion (Misc queries) 1 January 18th 05 06:37 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"