I need to extract a date from a text string. The string is a file name that will reside in a cell (and will be changed frequently. The date in blue is what I need extracted, only the date. I have extracted text strings before, however since I need to get it from the end (just before the file extension), AND the file is named with periods (instead of dashes) with the date... I am lost! Help! Thanks in advance!!!!
IIC WEEKLY - FRINGE BENEFITS RATES FOR PW PURPOSE AS OF 03.04.19.xlsx
Final desired format: 03-04-19