Extract date from text string between certain characters

Hi folk,

I'm struggling to pick out the numbers in a text string between certain characters AND return them as a UK date format.

The issue is partly as the characters appear twice in the string and I just want to ones at the end, before the file extension;

DOID20C_Scottish Family Living x4 (followers.10k)_02112019.png

I'm wanting to get the 02112019 after the second _ and before the .XXX that is the file extension, in this case .png

Can anyone assist please?

Thanks,

Ian

How about
=REPLACE(REPLACE(LEFT(TRIM(RIGHT(SUBSTITUTE(C4,"_",REPT(" ",100),2),100)),8),3,0,"/"),6,0,"/")+0

Thanks - it works except where there are more than 1 instance of _ before the last one, so ideally need to track from right end of string on the _ or find the last one regardless of how many prior there are

So here it is with solution 1 - the second one falls over if the date has any numbers after it (which, apologies, that variant wasn't in the original sheet) so have attached a second version

ChemistB - that has worked perfectly on all variants. Thank you.