Sorry, should also have mentioned:

There can sometimes be two dates within the same cell and the letters are not always fixed in the same place.

Attempted some VBA functions but one stripped out everything except numbers, which ruined the date format.