Can't graph data with Date Format with hours
 

I received a file with dates formatted using dd/mm/yy hh:mm and I want to
graph how many times a certain event occurs per date based on dd/mm/yy.
I tried using "COUNTIF" to determine how many entries exist per day, but it
does not find any match since the data contains hours and that is not
relevant to the graph.
I tried formatting the date field in the data using dd/mm/yy, but that only
changes the way the date shows in the cell but not the actual format. How do
I remove the hour:minute information?
Thanks,

Can't graph data with Date Format with hours
 

It's maybe longwinded but if the dates are in column B, insert a column at
column C. If the first date and time is in cell B7, enter in cell C7
=Trunc(B7,0). Copy it to all the other cells, they will all have the time
00:00. You can format column C and hide column B. If you want to get rid of
column B, insert a column at D, copy column C and paste values. Then you can
delete B and C.

"BRB" wrote:

I received a file with dates formatted using dd/mm/yy hh:mm and I want to
graph how many times a certain event occurs per date based on dd/mm/yy.
I tried using "COUNTIF" to determine how many entries exist per day, but it
does not find any match since the data contains hours and that is not
relevant to the graph.
I tried formatting the date field in the data using dd/mm/yy, but that only
changes the way the date shows in the cell but not the actual format. How do
I remove the hour:minute information?
Thanks,

Can't graph data with Date Format with hours
 

Thanks, that worked.

"Highland Cow" wrote:

It's maybe longwinded but if the dates are in column B, insert a column at
column C. If the first date and time is in cell B7, enter in cell C7
=Trunc(B7,0). Copy it to all the other cells, they will all have the time
00:00. You can format column C and hide column B. If you want to get rid of
column B, insert a column at D, copy column C and paste values. Then you can
delete B and C.

"BRB" wrote:

I received a file with dates formatted using dd/mm/yy hh:mm and I want to
graph how many times a certain event occurs per date based on dd/mm/yy.
I tried using "COUNTIF" to determine how many entries exist per day, but it
does not find any match since the data contains hours and that is not
relevant to the graph.
I tried formatting the date field in the data using dd/mm/yy, but that only
changes the way the date shows in the cell but not the actual format. How do
I remove the hour:minute information?
Thanks,