title: How can I get column filled with working-days (no weekend AND no vacations)?
body: <p>I'm trying to find a solution which will allow me to fill a table with the exact dates of working days (excluding weekends and also excluding a set of holidays) for a given period.</p>
  
  <p>In 'Sheet1'!A1 --> I enter the start-date
  In 'Sheet1'!B1 --> I enter the period (e.g 10 days)
  In 'Holidays'!B2:B, I have a list of dates of national holidays and vacation-days</p>
  
  <p>I currently use:</p>
  
  <pre><code>=FILTER(ArrayFormula('Sheet1'!A1+ROW('Sheet1'!YV1:YV14)-1),WEEKDAY('Sheet1'!A1+ROW('Sheet1'!YV1:YV14)-1,2)&lt;6)
  </code></pre>
  
  <p>Which provides me with a set of 10 weekdays starting from the date I enter, but
  a) the holidays are not taken into account and 
  b) also the range is set to fixed 10 days (I require flexibility in the defined period)</p>
  
  <p><strong>How can I get 'Sheet1'!C2:C to be filled with the 10 working days where no weekend AND no holidays are displayed?</strong></p>
  
  <p>Your help will be much appreciated!
  Cheers, Igor</p>