Dates

[Guest]

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,

 

[Pete_UK]

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

 

[Peo Sjoblom]

Try

=INT(A2)

if you get an error the dates and times are text

format result as mm/dd/yyyy


--


Regards,


Peo Sjoblom

 

[Guest]

thx! It works

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