how do I sort a column of random dates into Consecutive dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long column of random dates that need to be in order from oldest to
newest. How do I accomplish this in excel?
 
Data>Sort>Descending.


Gord Dibben MS Excel MVP

On Mon, 11 Jun 2007 20:54:00 -0700, Rob Gibson <Rob
 
Assuming these are real dates which are frozen values (and not formulas
containing RAND()), then just sort ascending on the dates col should do it
for you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge and Sort 2 worksheets into 3rd 4
Auto-sort worksheet by date in column A 3
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Consecutive date calculation involving holidays 1
First, Last occurance of date in column 5
Excel Average dates help 0
how to sort a column of Randomly selected numbers? 8
Sorting a worksheet with multiple columns 2

Back
Top