Hi all,

I have a quick question hoping someone could help. I'm trying to extract just the dates from a time based cell. (eg m/dd/yyyy) but can't seem to figure out the correct formula to do this.

Here's the structure

Cell A1 = 6/3/2011 12:11:41 PM (Format Cells shows m/d/yyyy h:mm)

Cell B1 (formula) : =LEFT(A1,FIND(" ",A1))

I'm getting a #VALUE! error no matter what i tried. I've attempted to change both cell formats to *3/14/2001 to no avail.

It would be really great if someone could help.

Thanks in advance.