Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Dates | Excel Worksheet Functions | |||
counting dates | Excel Worksheet Functions | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting individual dates | Excel Discussion (Misc queries) | |||
counting entries between two dates? | Excel Worksheet Functions |