View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jc9972003@yahoo.com is offline
external usenet poster
 
Posts: 38
Default Extract Date formula Only

On Tuesday, October 2, 2012 2:04:03 PM UTC-5, (unknown) wrote:
Hello can someone please help me. I'm exporting a report from a diffrent scource and in one section it has this "Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 Thank you


Thank you all for the help..