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,