Thread: Formula to get date from text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sara sara is offline
external usenet poster
  
Posts: 82
Default Formula to get date from text string
This is what the cell currently looks like:

[10/01/09 11:30PM]

I would like the formula to return only: 10/01/09

Does anyone know what formula I should use? Any help would be greatly
appreciated.

Thanks!!

Sara
Reply With QuoteReply With Quote