Formula to extract date from text in format dd/mm/yyy

[Howardc1001]

I have dates that have been downloaded and these are in text format in Col A

I need a formula to extract these in format dd/mm/yyyy in Col B


Your assistance is most appreciated

[Pete_UK]

You can use this formula in B1:

=DATE(RIGHT(A1,4),INT((FIND(LEFT(A1,3),"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3)+1,MID(A1,FIND(",",A1)-2,2))

then copy down.

Hope this helps.

Pete

[Howardc1001]

Hi Pete. Many Thanks. Formula works perfectly

[Pete_UK]

That's good to hear - thanks for the rep.

Pete