Extract Date formula Only
On Tuesday, October 2, 2012 12:04:03 PM UTC-7, (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
Try this, should work with both Oct 1 & Oct 12. (single & double digits days)
FYI: If the day is one digit, returns the month, day, year + space after year. Otherwise month, day & just year.
=MID(F14,FIND("(",F14)+2,12)
Regards,
Howard
|