Extract Date From a URL String

[pilot330]

Hi,

Would really appreciate a formula to extract the date in (CELL A2) from the string below, and then have that extracted date returned in lets say (Cell C2) in the format DD/MM/YYYY.

I have lots of these, but the date is always located between the sixth and seventh forward slashes.

Thanks.

https://www.timeform.com/horse-racing/racecards/lingfield-park/ 2021-01-30/1200/30/1/heed-your-hunch-at-betway-handicap

 

[FormR]

the date is always located between the sixth and seventh forward slashes.

Hi, here is one option.

Book4
	A	B
1	https://www.timeform.com/horse-racing/racecards/lingfield-park/2021-01-30/1200/30/1/heed-your-hunch-at-betway-handicap	30/01/2021
Sheet1

Cell Formulas
Range	Formula
B1	B1	=0+MID(A1,FIND("#",SUBSTITUTE(A1,"/","#",6))+1,10)

You may need to format the cell that contains the formula as a date.

 

[pilot330]

Perfect. Thanks very much, FormR.