Extract date from text

Hello,

I have data like

To_delivery_23-08_2019-2
To_quality_24-08-2019-2
Production_on_22-08-2019-5

I want extract DD-MM-YYYY from above text, before date the text length may vary and after date count also vary all the time.

Help me regarding this.
Thanks,
Prashanth.

Originally Posted by Rick Rothstein

Your dates seem to show that either a dash or underline can appear between the day and month as wall as the month and year... is that correct? If so, will there ever be any non-date numbers located before or after the date you are after next which have either a dash or underline character next to them? Also, is the day number always two digits long (leading zero for single digit day numbers).

In between date, months year always dash(-) and date always like 01, 02, 03 and months like as date

Thanks

Originally Posted by Prashanth.Akula

In between date, months year always dash(-) and date always like 01, 02, 03 and months like as date

Assuming there is never any dashes located before the date in your text, I think this should work (I cannot test it because my date order is different from yours)...

=0+LEFT(REPLACE(A1,1,FIND("-",A1)-3,""),10)