Extract a date from an Excel text string

I have this spreadsheet, one of the cells is a text string, it might contain a date, I need to extract this date. I found a VBA function that will work some times. The problem is, in that same text string, there is another piece of data that looks like: “S/N 000-0000-0000”. I have found that when this S/N is there, the function would either return a negative date or the wrong value for the date and I do not know how to parse and eliminate this S/N before I extract the date.