Thread: Date Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Date Function

=DATEVALUE(MID(A2,FIND("/",A2)-2,10))

Format as date.

--
Best Regards,

Luke M
"Jen_T" wrote in message
...
If a cell has text and numeric (date) is there a way to pull the date out
easily ?
E.g.
Product dropped off on 11/01/2009 by Michelle Smith
I would like to see 11/01/2009

Thank you