I have a column of (event) dates where the usual entry is a single date,
however, sometimes an event runs over two days so I would need to enter two
dates within a cell - see example below.

01/06/08
01/07/08 - 02/07/08

I've formatted the column as date but the two day events always sort to the
top/bottom of the column depending on the ascending/decending sort. Is it
possible to get the two day cells to sort based on the first date (in the
above example 01/07/08) ?

If this is not possible I guess the only way is to make separate columns for
the start/end date and then sort on the start date column.

Thanks for any advice.

Dave