Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to make a schedule listing that can be sorted by dates of tradeshows if need be, but some of them are multiple days. I know how to sort columns by month, but it doesn't sort them correctly when it is followed by a range of dates.


January 10-15, September 3-7, or August 4-5

How can I get these to sorted?

share|improve this question

For Excel, those are not date ranges, but opaque Strings. The clean solution would be to create two columns, Start date and End date, and just set the end date to the start date for one-day trade shows.

If you cannot do that: You can try to create a hidden column that extracts the month name with string operations (find where the space is, then take that many characters from the left), then sort on that. (You can use VLOOKUP/HLOOKUP to map from month names to numbers).

share|improve this answer
Thank you for the help! I really didn't understand much about the second option, but I suppose I'll have to play around with it and see. – llindenberg Jan 24 '13 at 20:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.