Convert date from words to normal date

[James Clear]

Hi team,

Would like to convert 10th Jan’23 to proper date as 10/01/2023 … how can I convert this by formula? Pls suggest.

 

[Dave Patton]

Dates Time.xlsm
	A	B
1
2	10th Jan’23	10-Jan-23
3	4th Jan’23	4-Jan-23
3d

Cell Formulas
Range	Formula
B2:B3	B2	=DATE("20"&RIGHT(A2,2),MONTH(MID(A2,FIND(" ",A2)+1,3)&1),IFERROR(--LEFT(A2,2),--LEFT(A2,1)))