Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
Try

=INT(A2)

if you get an error the dates and times are text

format result as mm/dd/yyyy


--


Regards,


Peo Sjoblom
 
thx! It works :)

Pete_UK said:
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
Click to expand...
 
Back
Top