S
seang
,
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
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