Excel programming
 

,

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 calls
logged per a day. I want to run some sql queries which will identify
how many calls were logged on a certain day.

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

8/01/2004 03:32:57 PM

Now, my problem is i'm trying to count how many times the date appears
in the page i can't match it up against anything. I am using this
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 only
appears in the cell. I dont mind even copy the date in to an adjacent
cell.. I just need the date split away from the time.

Any help you can provide will be appreciated.

Regards,

sean


---
Message posted from http://www.ExcelForum.com/

Excel programming
 

If A1 contains your date, then try the following formula in B1:
=INT(A1)


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"seang " wrote in message
...
,

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 calls
logged per a day. I want to run some sql queries which will identify
how many calls were logged on a certain day.

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

8/01/2004 03:32:57 PM

Now, my problem is i'm trying to count how many times the date appears
in the page i can't match it up against anything. I am using this
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 only
appears in the cell. I dont mind even copy the date in to an adjacent
cell.. I just need the date split away from the time.

Any help you can provide will be appreciated.

Regards,

sean


---
Message posted from http://www.ExcelForum.com/