To extract the month/day part of date try

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND(" DUE ",A1)+5,255),"/",REPT(" ",10),2),10))

If this post helps click Yes
---------------
Jacob Skaria


"Sue Compelling" wrote:

Hi

I have a report that is populated from a data dump from our work management
system. One of the cells will say something like below and will always
contain a date after the word DUE...

VODAFONE P3 INC526642 SITE: SOJ Shotover Jet HQ DUE 4/11/09 16:09

I want to be able to selct only the date (which somethimes will only read
4/11 - I tried the following formula (from this forum) though am coming
unstuck ...

=RIGHT(R2,FIND("DUE",R2&"DUE"))

as it returns the following when run across the above string ...

26642 SITE: SOJ Shotover Jet HQ DUE 4/11/09 16:09

TIA ...
--
Sue Compelling