• Excel Book Excerpt

Excel Sort Days of the Week

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.

LE10000620.jpg 

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.

Excel will sort the data correctly.

LE10000622.jpg 

Figure 601 Weekdays are sorted correctly.

 

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:



Popular Pages

More Info