Extract Date from Right Formula

[[email protected]]

SSBuZWVkIGEgZm9ybXVsYSB0aGF0IHdpbGwgZXh0cmFjdCB0aGUgbGFzdCBkYXRlIGZyb20gdGhl
c2UgdHlwZSBvZgpzdHJpbmdzLgoKMDcvMTIvMjAwNgwMMDcvMTIvMjAwNgwMMDcvMTIvMjAwNgwM
MDcvMTcvMjAwNgwMLQwMIC0KCk9yIAoKMDcvMTIvMjAwNgwMLQoKT3IKCjA3LzA3LzIwMDYMDDA3
LzA3LzIwMDYMDC0MDC0MDC0MDC0KCi1TdGV2ZQo=

[JE McGimpsey]

One way:

=MID(A1, FIND("^", SUBSTITUTE(A1, "/", "^", LEN(A1) -
LEN(SUBSTITUTE(A1, "/", "")))) - 5, 10)


"[email protected]" <[email protected]> wrote:

> I need a formula that will extract the last date from these type of
> strings.
>
> 07/12/2006 07/12/2006 07/12/2006 07/17/2006 - -
>
> Or
>
> 07/12/2006 -
>
> Or
>
> 07/07/2006 07/07/2006 - - - -
>
> -Steve

[[email protected]]

uh - - - WOW - I don't know how you guys keep coming up with this
stuff, but this worked perfectly the 1st time. Great work, thanks for
the help.

JE McGimpsey wrote:
> One way:
>
> =MID(A1, FIND("^", SUBSTITUTE(A1, "/", "^", LEN(A1) -
> LEN(SUBSTITUTE(A1, "/", "")))) - 5, 10)

[daddylonglegs]

Another way...

=RIGHT(TRIM(SUBSTITUTE(A1,"-","")),10)

gives a text result, as does previous suggestion. For a true date

=RIGHT(TRIM(SUBSTITUTE(A1,"-","")),10)+0

format as date