title: Using MMULT to populate Gantt chart
body: <p>Trying to use <code>MMULT</code> to populate this Gantt chart with a single formula.  </p>
  
  <p>This is what I'm trying that's not working</p>
  
  <pre><code>=MMULT(--($E4:E&lt;=G$1:1),--($F4:F&gt;=G$1:1))` 
  </code></pre>
  
  <p>(I have it reversed in the image by accident; the same result though)</p>
  
  <p>edit: This seems to be closer, but still not filling all cells...</p>
  
  <pre><code>=MMULT(IF($E4:$E&lt;=G$1:$1,1,0),IF($F4:$F&gt;=G$1:$1,1,0))
  </code></pre>
  
  <p>This is what I'm using to get the proper outcome, but I have to drag across every cell.</p>
  
  <pre><code>=IF(AND(G$1&gt;=$E4,G$1&lt;=$F4),"x",)
  </code></pre>
  
  <p>What am I doing wrong with the <code>MMULT</code> formula?  Tried wrapping in <code>ARRAYFORMULA</code> without luck.  Tried using <code>COUNTIF</code>, no luck there either...</p>
  
  <p>Here is my <a href="https://docs.google.com/spreadsheets/d/1wrWUFNqwEm7hhOQROSAtOVPDN7Ca7UYNlf1A5KZ8Qns/edit?usp=sharing" rel="nofollow noreferrer">sample sheet</a></p>
  
  <p><a href="https://i.stack.imgur.com/Uet6W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Uet6W.png" alt="enter image description here"></a></p>
  
  <p>This is what I'm trying to accomplish:
  <a href="https://i.stack.imgur.com/kZ2Ou.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kZ2Ou.png" alt="enter image description here"></a></p>