OK this one is definitely for the experts here.

I have a listing with about 6 columns and 100 rows of data.
I'd like to sort the data by the date column.
The problem is that currently, the date column has the date in the
following text format:

Thu Jun 15-Sat Jun 17
Fri Jun 9-Mon Jun 19, var. concerts/ venues
Sat Jun 23-Sat Aug 26, many concerts


So in addition to being a text field, there is sometimes extra text
added at the end of the field.

Would anyone here be able to tell me how I can sort all of this data
chronologically by date?

TIA Ric