change "date + time" to "date" only

Tabo · May 20, 2004

Dear expert, I have a large nos. of date value as follow:

5/13/2004 12:43:36 P

Q: how can I delete the time value only, so that I can count it by date

Many Thank

Tabo

Frank Kabel · May 20, 2004

Hi
use
=INT(A1)
and format this cell as 'Date'

change "date + time" to "date" only

Tabo

Frank Kabel