Utilizing COUNTIF and TRUNC

[sungersoo]

Hello,

I am trying to run a running formula where I would need to do a countif with a trunc or int on a date

i.e. What I'm trying to achieve

Column A
10/4/2017 8:20:53 PM
9/14/2017 22:37
10/4/2017 0:11
10/2/2017 22:36
10/4/2017 16:53
10/4/2017 20:16
10/4/2017 19:00
10/4/2017 19:00
10/4/2017 19:00
10/5/2017 18:04
10/5/2017 19:38
10/6/2017 20:46
10/9/2017 21:31
10/6/2017 22:41
10/12/2017 18:21
10/16/2017 17:26
10/16/2017 19:12
10/16/2017 23:33
10/17/2017 2:48
10/17/2017 13:27


Column B
10/4/2017

COUNTIF(TRUNC(A:A),B1) but not possible. Can anyone give a helping hand please?

 

[Jonmo1]

You can't manipulate the range of data like that in countif.

Try
=COUNTIFS(A:A,">="&B1,A:A,"<"&B1+1)

 

[sungersoo]

You can't manipulate the range of data like that in countif.

Try
=COUNTIFS(A:A,">="&B1,A:A,"<"&B1+1)

Thank you! Works Perfectly.

 

[Jonmo1]

You're welcome.