title: google spreadsheets FILTER multiple columns
body: <p>I created a contact register with the following structure:</p>
  
  <pre><code>id + lastname + name + phone + mobile + adress + birthdate + ...
  </code></pre>
  
  <p>Now, I just want to filter for contacts which are having birthday in the next 7 days and show lastname, phone and birthdate...</p>
  
  <p>So I tried this: (please ignore pseudocode in the conditions)</p>
  
  <pre><code>=FILTER({B:D, F:G}; DAYS([Birthdate];[TODAY()])&gt;=0; 
                DAYS([Birthdate];[TODAY()])&lt;=7)
  </code></pre>
  
  <p>I also tried this from a post in the <a href="https://productforums.google.com/d/msg/docs/-lHbCWYwVTU/vk6CBYNLAQAJ" rel="nofollow noreferrer">Google Docs Help Forum
  </a>, but I always  get <code>Error, Formula parse error.</code>.</p>
  
  <p>When I separate the column with ; I get <code>Error, FILTER has mismatched range sizes. Expected row count: 356. column count: 1. Actual row count: 178, column count: 1.</code></p>
  
  <p>How can I concatenate the rages?</p>