title: Excel IF + AND + Date range formula
body: <p>I am looking to create and IF function that does the following.</p>
  
  <p>There is a ton of data with one column containing dates. I want and if functions that labels each row according to the following.</p>
  
  <p>If date falls between 0-30 days of todays date in the past then label "GOOD" (so if todays date is 21/09/2017 then it should be labelled as "GOOD" should it falls between the dates 21/09/2017 and 21/08/2017)</p>
  
  <p>If date falls between 31-60 days of todays date in the past then label "FAIR"</p>
  
  <p>If date falls between 61-90 days of todays date in the past then label "ATTENTION"</p>
  
  <p>If date falls between 91+ days of todays date in the past then label "CLEARANCE"</p>
  
  <p>Hope someone can help.</p>
  
  <p>Many thanks</p>