Google sheets countif same date

Question

I have two columns. The first one records when a signup happens (with the time), and the second one is a simple date increment that should count how many signups happened within that day.

For example, for 2022-07-13, the answer should be 2 (2022-07-13 2:32:12 and 2022-07-13 12:30:59)

My formula was: =COUNTIF(A:A,TO_TEXT(B2&"*"))

• Turn 2022-07-13 date into a text, and look for 2022-07-13* matches in A:A, so I was expecting that 2022-07-13 2:32:12 and 2022-07-13 12:30:59 show up, however it is still showing 0

Answer 1

You need COUNTIFS() instead COUNTIF()

=COUNTIFS(A2:A,">="&B2,A2:A,"<"&(B2+1))

Answer 2

You could rearrange your sheet to something more "readable" and use the following single formula:

=INDEX(IF(LEN(B2:B22), 
    COUNTIF(INDEX(IFERROR(SPLIT(A2:A22," ")),,1),B2:B22),))

(Please adjust ranges according to your needs)

Functions used:

• INDEX
• IFERROR
• IF
• LEN
• COUNTIF
• SPLIT