Thread: Counting dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Juan_Quar
 
Posts: n/a
Default Counting dates

I have data like this:

18/3/06 23:22
21/3/06 17:45
24/3/06 12:25
24/3/06 14:30
28/3/06 15:36
28/3/06 22:38

and I would like to be able to count how many enteries were made on a
date. (ie 18/3/06 = 1, 21/3/06 = 1, 24/3/06 2 etc) So far I have drawn
a blank as I keep getting stimied by the time in the date:time stamp.
My count is always = 1??

Ideally a look up table would be cool but I have no idea how to start
that!! ie just returning a date and count as a list.

Can anybody help?

Juan_Quar