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

Counting dates
 

Have you thought of using a pivot table?

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=527535

Counting dates
 

You need to lose the time element from your dates. In the column next to
your dates and times enter the formula =Int([cell refernce]) e.g.
Int(A2), format these cells with the data format you want i.e.
dd/mm/yyyy, you now have the date on its own without the time. Then you
have a number of options, either create a pivot table using you new
column as the row and data field, or use a countif(range,date).

Therefore assuming your dates are in cells A1 to A6 and your Int
formula is in B1 to B6. In cell A10 enter a date from the list in A1 to
A6 and then in cell B10 enter the following formula:-

=COUNTIF(B1:B6,A10)

This should give you what you want


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=527535

Counting dates
 

Does =date(year(A1),month(A1),year(A1)) give you a viable date for a countif?

"Juan_Quar" wrote:

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

Counting dates
 

Thank you all for your help. I have resolved the date count the way
Gary described. I am now looking at pivot tables as I have never used
them.

Kind regards all