The sample you give is all text/values...

How is the date entered? As a manually-entered numeric using a date format? As a string from an external application?

If the latter, it would probably be easier to change the source date format - if that's feasible.

The time suffix introduces a content variable that would play havoc with matching and the leading zero-suppression on day and month numbers doesn't help either.

The leading "Day" value seems fixed length at 3 characters, so is a not a challenge to strip off.

Ideally, if source of data is another Excel sheet, ensure that both source and destination date columns share the same Excel data format and bring in that date as an Excel date. Then you chop it up into Year, Month and Day if you need to obtain totals by day, month and/or year.

Sorry...

Dave