Hello.

We have a spreadsheet where the data in column A are dates. Some of the
entries, however, have been put in as date ranges in one cell (i.e., 01/01/06
- 01/11/06). We need to be able to still sort the list by date. Can cells
that have a date range entered still be formatted to read as a date so the
sorting includes them?

This is an example of what we have:
12/04/05
12/06/05
01/01/06 - 01/11/06
12/12/05
01/12/06
01/01/05

This is what we need to sort to without splitting the column:
01/01/05
12/04/05
12/06/05
12/12/05
01/01/06 - 01/11/06
01/12/06

Thank you in advance for any suggestions.