title: Excel 3 value IF statement using date ranges
body: <p>I am trying to create a conditional formatting for a range of dates.  I want anything longer than 30 days away to format green, anything within 8-30 days to be yellow and anything less than 8 days to be red.</p>
  
  <p>I have tried the following formula without any luck:</p>
  
  <pre><code>=IF(H56&lt;=Today()+7,"1",IF(AND(H56&lt;Today()+30,H56&gt;=Today()+8,"2","")))
  </code></pre>
  
  <p>Any help would be greatly appreciated.  Thanks.</p>