title: I'm stuck on how to "match" 2 columns of date and time in Google Sheets
body: <p>first timer here.</p>
  <p>I've been stuck on creating a formula to calculate how many &quot;leads&quot; were created and modified on the same day with the &quot;B2C Lead Name&quot; being a name. I've redacted some numbers and names for obvious reason.</p>
  <p>As you can see, row 8 and 9 for both column B and D fall on the same date. And B2C Lead Name is &quot;Boom.&quot; On the top right corner, I've tried multiple ways I could think of to count the instances where the lead was created on Aug 30 and was also modified on Aug 30 while the Lead Name is Boom, but I haven't managed to have it work when at least my formula should've shown 3.</p>
  <p>For context, I'm creating a report for my sales team and I've been stuck on this thing for 3 weeks, so any help on this would be extremely appreciated. And if it's not too much to ask, please also school me on why using DATEVALUE and trying to &quot;match&quot; those time and date columns as a criterion doesn't work?</p>
  <p>Please let me know if you need any more details on this. Thank you!</p>
  <p>Here's what I've been staring at for the past 3 weeks, among countless others: <code>=ARRAYFORMULA(COUNTUNIQUEIFS(NMZHImport!$A:$A,NMZHImport!$G:$G,&quot;*&quot;&amp;U30&amp;&quot;*&quot;,DATEVALUE(NMZHImport!$B:$B),&quot;=&quot;&amp;DATEVALUE(NMZHImport!$D:$D),NMZHImport!$N:$N,&quot;&lt;&gt;Appointment Confirmation&quot;))</code></p>
  <p><a href="https://i.stack.imgur.com/ymruu.png" rel="nofollow noreferrer">Sheet</a></p>