Try this...

=INT(MID(A1,SEARCH("Due",A1)+4,20))

Format as Date

--
Biff
Microsoft Excel MVP


"Sue Compelling" wrote in message
...
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