count No of time a date occure in column.

[iqss]

hi
i have a column with date and time want to know how many times a date has been entered in a column irrespective of time.

file attch

thanks

[EdRooney]

Have you tried a pivot table?

[AliGW]

One way:

=COUNTIFS($A$2:$A$32,">="&G2,$A$2:$A$32,"<"&G2+1)

Another way:

=SUMPRODUCT(($A$2:$A$32>=G2)*($A$2:$A$32<G2+1))

[iqss]

hi sir

the second answer is working.

thanks AliGW..

[AliGW]

In what way did they not help?

They worked perfectly for me.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I
1	DATE IN /TIME	DATE OUT /TIME						no of entries on date
2	01/08/2018 10:30	01/08/2018 15:30					01/08/2018	7	7
3	01/08/2018 14:35	02/08/2018 06:20					02/08/2018	7	7
4	01/08/2018 15:35	03/08/2018 14:10					03/08/2018	17	17
5	01/08/2018 17:40	03/08/2018 10:10					04/08/2018	0	0
6	01/08/2018 14:30	05/08/2018 14:30					05/08/2018	0	0
7	01/08/2018 19:35	02/08/2018 06:45					06/08/2018	0	0
8	01/08/2018 20:00	02/08/2018 16:05					07/08/2018	0	0
9	02/08/2018 04:00	02/08/2018 19:20					08/08/2018	0	0
10	02/08/2018 08:15	02/08/2018 18:00					09/08/2018	0	0
11	02/08/2018 20:15	03/08/2018 02:50					10/08/2018	0	0
12	02/08/2018 20:40	02/08/2018 22:15					11/08/2018	0	0
13	02/08/2018 23:00	03/08/2018 08:40					12/08/2018	0	0
14	02/08/2018 23:45	03/08/2018 08:35					13/08/2018	0	0
15	02/08/2018 23:55	03/08/2018 07:50					14/08/2018	0	0
16	03/08/2018 07:00	03/08/2018 21:00					15/08/2018	0	0
17	03/08/2018 14:30	04/08/2018 08:50					16/08/2018	0	0
18	03/08/2018 16:50	04/08/2018 10:50					17/08/2018	0	0
19	03/08/2018 18:00	04/08/2018 12:25					18/08/2018	0	0
20	03/08/2018 19:15	04/08/2018 16:15					19/08/2018	0	0
21	03/08/2018 20:10	04/08/2018 20:10					20/08/2018	0	0
22	03/08/2018 20:20	04/08/2018 16:35					21/08/2018	0	0
23	03/08/2018 20:30	04/08/2018 20:00					22/08/2018	0	0
24	03/08/2018 21:40	05/08/2018 13:30					23/08/2018	0	0
25	03/08/2018 22:30	04/08/2018 11:20					24/08/2018	0	0
26	03/08/2018 22:30	04/08/2018 10:50					25/08/2018	0	0
27	03/08/2018 22:46	04/08/2018 22:00					26/08/2018	0	0
28	03/08/2018 23:30	05/08/2018 19:30					27/08/2018	0	0
29	03/08/2018 23:25	06/08/2018 12:30					28/08/2018	0	0
30	03/08/2018 23:35	04/08/2018 08:40					29/08/2018	0	0
31	03/08/2018 23:30	04/08/2018 08:40					30/08/2018	0	0
32	03/08/2018 23:30	04/08/2018 08:40

Sheet: AUG 18

[iqss]

hi

sorry pl read my post i said second option is working for me.

anyways thanks ALiGW.

[AliGW]

Yes, but you edited your post 15 minutes after I had posted my response to what you had said originally, which was that they did not help! Please do NOT post-edit your messages - it makes a complete nonsense of the thread.

Anyway, I am glad one of them worked for you ... in the end!