title: Excel - comparing a cell with a concatenated value in an IF statement
body: <p>I understand that <code>CONCATENATE()</code> returns a string but hopefully the formula below should help provide some context and what I'm trying to achieve:</p>
  
  <p>I need the cell to say <code>YES</code> or <code>NO</code> depending on whether a date is within a specific range.</p>
  
  <ul>
  <li>V3 = <code>1.1</code></li>
  <li>C5 = <code>01/01/2014</code></li>
  <li>D5 = <code>01/02/2014</code></li>
  </ul>
  
  <p></p>
  
  <pre><code>=IF(AND(V$3&gt;=CONCATENATE(DAY($C5),".",MONTH($C5)),
     V$3&lt;=CONCATENATE(DAY($D5),".",MONTH($D5))),"YES","NO")
  </code></pre>