title: Count worktime for current month only
body: <p>I would like to ask for a bit of help, as I can't figure it out myself.</p>
  <p>What I would like to end up is, get the total calculation of the work time hours for each name only for the month written in A5 cell.</p>
  <p>So far I used this code to have the start date Monday, based on the date in A5 cell.</p>
  <pre><code>=A5-MOD(A5-2,7)
  </code></pre>
  <p>With this community help I ended up with this code to count the work time for each name in the week (lots of students in the schedule)</p>
  <pre><code>=SUMPRODUCT(IFERROR(TIMEVALUE(MID(C7:H7,FIND(&quot;-&quot;,C7:H7,1)+1,LEN(C7:H7)-FIND(&quot;-&quot;,C7:H7,1))) - TIMEVALUE(LEFT(C7:H7,FIND(&quot;-&quot;,C7:H7,1)-1)),0))
  </code></pre>
  <p>The help I need, if it's possible, is to figure out how to get the total work time only for the month entered in cell A5 (which is 1.october - 31.october) without counting the last 3 days in September. I plan to use this spreadsheet for the following months as well. I tried to use COUNTIFS, but no luck so far. Also, I am using an online excel version, which is very limited in the menu.</p>
  <p>Thanks in advance for any help.</p>
  <p><a href="https://i.stack.imgur.com/dAkYr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dAkYr.png" alt="work schedule" /></a></p>