title: Using vlookup to find date over 30 days
body: <p>I am using this formula in B1 </p>
  
  <pre><code>=today() -30
  </code></pre>
  
  <p>I use this to show a the day 30 days ago.</p>
  
  <p>Colum C2 is a list of account numbers and D3 is the dates, I am trying to list all account number that have dates over 30 days on them</p>
  
  <p>I am trying to use the following formula:</p>
  
  <pre><code>=vlookup(C:C,C2:D22,'&lt;=B1',TRUE)
  </code></pre>
  
  <p>This doesnt work, but cant get my head around why.</p>
  
  <p>Any help would be appreciated</p>