View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] steven.britton@meridian-yachts.com is offline
external usenet poster
 
Posts: 14
Default Extract Date from Right Formula

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)