This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Sort Days of the Week
Problem: I have a column with values such as Monday, Wednesday, and so on. When I sort this column in ascending sequence, Friday comes before Monday. The same problem happens with month names, which sort as April, August, December, and so on.
Figure 600 Friday is alphabetically before Monday.
Strategy: Excel has custom lists built in for months and days. To use them, follow these steps:
1. Select a cell in your data.
2. Select Data, Sort.
3. Choose Sort by Day and Sort on Values. In the Order dropdown, choose Custom List.
4. Choose Sunday, Monday, Tuesday from the Custom List dialog. Click OK.