If your date/times are in column A, put this formula in B1:

=INT(A1)

Format as date and copy down as necessary.

Hope this helps.

Pete

On Nov 9, 12:01 am, Talladega
wrote:
Hi,

I have a series of dates and time in each row. I want to create a formula
that will only take the dates. ex:

before after
11/05/2007 5:15pm 11/05/2007
12/31/2007 3:13pm 12/31/2007
09/27/2007 12.31pm 09/27/2007

Thanks,