In cell C1 I have the follow string:
O:\Data\Search Requests\2019\20190107 - Christine_Smith
I'm looking for a way to get the date 20190107 in cell A1.
Cell A1 is date formatted so it needs to recognize it as a date, not sure if the only way to do that is 01/07/2019.
Maybe a search starting...