title: How to add Excel formula to compare date with Today
body: <p>I have a EXCEL template of many sheets. There are two sheets whose data is depend on each other. I want to add overdue Column in sheet which compare date column of another sheet with Today if it is less than today then count it.
  Here is the excel formula(s) that I have been trying but does not work.</p>
  <blockquote>
  <ol>
  <li>=COUNTIFS('Task Worksheet'!A:A,C3,'Task Worksheet'!C:C,&quot;In Progress&quot;,'Task Worksheet'!E:E,&quot;&lt;TODAY()&quot;)</li>
  <li>=COUNTIFS('Task Worksheet'!A:A,C34,'Task Worksheet'!C:C,&quot;In Progress&quot;,'Task Worksheet'!E:E,&quot;&lt;&quot;&amp;TODAY())</li>
  </ol>
  </blockquote>
  <p>Here is the Excel Screenshots.</p>
  <p><a href="https://i.stack.imgur.com/lRMcM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lRMcM.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/cX7KV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cX7KV.png" alt="enter image description here" /></a></p>
  <p>If you notice, <strong>Brad Parsons shows 4 in Overdue but it should be 3</strong>. because for Brad Parsons In Task Worksheet there are 4 rows for In Progress status but Overdue(s) is 3 but it shows 4.
  I need help. The formula i used here is &quot;if Task Worksheet <strong>Assigned To(A)</strong> equal To Current Sheet <strong>Sales Rep</strong> and Task Worksheet <strong>Status equal(C)</strong> In Progress and Task Worksheet <strong>End Date(E)</strong> is less than Today then count it. According to my logic for Brad Parsons Overdue column value should be 3. I spent alot to fix it but not succeed. Please Help me out.</p>