title: Using WEEKDAY function inside a COUNTIFS
body: <p>I want to count the times John was in the blue room and it was a thursday. I played with <strong>COUNTIFS</strong> and <strong>WEEKDAY</strong> and checked the documentation.      </p>
  
  <p>I tried <strong>COUNTIFS</strong> with two conditions but got errors or 0 as a result.</p>
  
  <p><img src="https://i.stack.imgur.com/vgTxQ.jpg" alt="Click to see the excel sheet screenshot"></p>