title: Date copmarison in SumIfs Formula not working
body: <p>I try to compare the current date to dates in one column but it gives me &quot;0&quot; all the time.
  Before I added the date comparison within the &quot;SumIfs&quot; formula it worked well.</p>
  <pre><code>Dim ClaimR As Workbook
  
  With ClaimR.Sheets(1).Columns(10) 'Column &quot;J&quot;
      .NumberFormat = &quot;DD.MM.YY&quot;
  End With
  
  Dim today As Date
  today = Format(Date)
  
  
      HoursAmount = Application.WorksheetFunction.SumIfs(ClaimR.Sheets(1).Range(&quot;I:I&quot;), ClaimR.Sheets(1).Range(&quot;G:G&quot;), serial, ClaimR.Sheets(1).Range(&quot;U:U&quot;), &quot;Vacation&quot;, ClaimR.Sheets(1).Range(&quot;J:J&quot;), &quot;&lt;=&quot; &amp; today)
  </code></pre>
  <p>I've read some related issues but I don't get what's wrong with my code.</p>