Dates
 

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,

Dates
 

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,

Dates
 

Try

=INT(A2)

if you get an error the dates and times are text

format result as mm/dd/yyyy


--


Regards,


Peo Sjoblom


"Talladega" wrote in message
...
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,

Dates
 

thx! It works :)

"Pete_UK" wrote:

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,