title: COUNTIFS yesterday?
body: <p>So I currently have the formula (shown below) that lets me count records with yesterday's date on.</p>
  
  <pre><code>=COUNTIFS(A100:A6228,"="&amp;TODAY()-1)
  </code></pre>
  
  <p>The problem with this formula is that on a Monday when I go to use it, I get a total of 0 because the day before is Sunday.</p>
  
  <p>I'm looking for a solution that uses weekdays only (mon-fri). So when I go to use the formula on Monday I get records from the Friday before.</p>
  
  <p>Thanks in advance!</p>