Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting dates
How do I sort a column filled with dates by Month, Day, then Year? The
default seems to be to sort by year first, then month. |
#2
|
|||
|
|||
Hi!
Here's an idea. Assume dates are in column A, A1:An. You need 3 helper columns: B, C, and D. In B1, C1 and D1 enter these formulas respectively: =MONTH(A1) =DAY(A1) =YEAR(A1) Select cells B1, C1 and D1 and copy down to the end of the list of dates in column A. With that range still selected do a Copy/Paste Special/Values Now, select the entire range A1:Dn Sort by column B then by column C then by column D. When done and satisified, get rid of the helper data. Biff "Heather" wrote in message ... How do I sort a column filled with dates by Month, Day, then Year? The default seems to be to sort by year first, then month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
sorting using dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
Sorting dates | Excel Worksheet Functions |