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

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

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)

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=562280