Remove Time Stamp Out of Cell

[mycon73]

Hi,

I have the following in a single cell, which was extracted from another source:

11/14/2012 12:39:47 PM
(In cell C5)

I'm trying to use the date as a criteria to pull various metrics, but not sure if the time format is altering the results.

What's a good function to remove the time stamp?

Thanks

[Moo the Dog]

If that is in cell C5, then in C6 (or any other cell) you could enter:

=LEFT(C5,SEARCH(".",C5)-1)*1

Then format that cell as 'Date'

- Moo

[Ace_XL]

Another way..

=DATE(YEAR(C5),MONTH(C5),DAY(C5))

[shg]

=int(c5) .

[mycon73]

Hi Everyone,

All these functions works great!!!

My problem is solved...