for the other spreadsheet insert a column in front of the data and add the following:

MID(B1,IF(RIGHT(LEFT(B1,FIND("-",B1)-2),1)=" ",FIND("-",B1)-1,FIND("-",B1)-2),IF(RIGHT(LEFT(B1,FIND("-",B1)-2),1)=" ",5,6))

in as the formula in column A, then use the same Data->Filter->Autofilter, then as you sort or filter column A by date, you see what you need.

If this is not answering your problems, please attach a workbook containing sample data for us to look at.

Have a great day.