One way:

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


" 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