Extracting Date from Text

[joeylee]

I am trying to extract a date from text of varying length.

Examples:
Insulated and 2-Side set by jlee on 8/8/2019 at 3:24:20 PM

USACE/White MEP Framing Inspection set by jlee on 8/6/2019 at 6:38:39 PM

White Inspection set by jlee on 8/7/2019 at 7:31:10 AM


I used the equation:
=MID(A1,(FIND("/",A1,1)-2),10)

Which returns the correct date in the format ??/??/???? for all except the entries with a slash at the beginning of the entry.

How can I input a function to only take the end "/" as the correct one?

 

[tyija1995]

Hey,

try with this wildcard:

=IFERROR(MID(A1,SEARCH("/?/",A1)-2,10),MID(A1,SEARCH("/??/",A1)-2,10))

 

[joeylee]

It worked great, Thank you!