Splitting Data to separate files - does not work with "date" as the filter

[snuffnchess]

I am looking to run the attached file but to split the sheets based on the "Date" field, which seems to cause issues.

This is a weekly file that would have to be run, so rather than focusing on the date (because in reality the date is not important, it is only used as a split filter), I was thinking that if there was a way to essentially Take the unique dates that appear,
sort them from smallest to largest, and then replace the smallest with a "1", next "2", etc... up to 5.

Or even with a name? Ship Date 1 will always be a thursday, 2 a friday, 3 Monday, 4 Tuesday, 5, wednesday.

I have found that if i manually put in a number or type in a day name that the split works fine... even if i convert the date to a number it works fine... it is only when it is in date format that it does not work.