Thanks for the feedback. Try the below

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

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


"Sue Compelling" wrote:

Jacob - that's brilliant -

You make excel sing!!!

Tell me - if the user has only entered 5/11 as the date - in extracting it -
how do I add on the current year so that it reads 5/11/2009?

Cheers
--
Sue Compelling


"Jacob Skaria" wrote:

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