Modifying a cell

  • Thread starter Thread starter seang
  • Start date Start date
S

seang

Hi,

I'm stuck with a problem.. I hope you will be able to help me.

I have an odbc connection to an sql database which stores data on call
logged per a day. I want to run some sql queries which will identif
how many calls were logged on a certain day.

When I import the data in to my excel spreadsheet, the date appear
with the time next to it. The following is an example of what the cel
looks like:

8/01/2004 03:32:57 PM

Now, my problem is i'm trying to count how many times the date appear
in the page i can't match it up against anything. I am using thi
formula:

=SUM(IF($E$4:$E$32=B39,1,0))

The b39 is for example 8/1/2004

How can i seperate the 8/01/2004 03:32:57 PM so that the date onl
appears in the cell. I dont mind even copy the date in to an adjacen
cell.. I just need the date split away from the time.

Any help you can provide will be appreciated.

Regards,

sea
 
Hi
one way:
in an adajcent cell insert the formula
=INT(A1)
and format this as date (assumption A is your date column)
copy down
 
Back
Top