Hello Guys,
Im trying to extract some dates in any format (ex: 20Jun2020, 20Nov19, 1/31/2019, etc.) I managed to extract some by using
=MID(A1,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789",1)),LEN(A1)+1)),LOOKUP(1,0*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1)))) + 1  MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789",1)),LEN(A1)+1)))
However some come out like this (see below) any way to more efficient extract the dates in any format even though other numbers are in the entry? Thank you guys in advance
Im trying to extract some dates in any format (ex: 20Jun2020, 20Nov19, 1/31/2019, etc.) I managed to extract some by using
=MID(A1,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789",1)),LEN(A1)+1)),LOOKUP(1,0*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1)))) + 1  MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789",1)),LEN(A1)+1)))
However some come out like this (see below) any way to more efficient extract the dates in any format even though other numbers are in the entry? Thank you guys in advance
2/Ref 4/10MAY2018
