title: Match current date with selection and return cell address
body: <p>I have a row containing dates:</p>
  
  <pre><code>05/10/15    06/10/15    07/10/15    08/10/15    09/10/15    10/10/15    11/10/15
  D3:J3
  </code></pre>
  
  <p>I have a cell (<code>D5</code>) with the following value:</p>
  
  <pre><code>=NOW()
  //Returns "07/10/15"
  //The cell is formatted to exclude time.
  </code></pre>
  
  <p>I have this function (E5):</p>
  
  <pre><code>=ADDRESS(3,MATCH(D5,D3:J3,0),1,4)
  </code></pre>
  
  <p>The aim is to match the current date with a date from a given selection and return the cell address. The function does not work and I am not sure what I am missing.</p>
  
  <p>I added the following function to check the values:</p>
  
  <pre><code>=IF(F3=D5,TRUE,FALSE)
  </code></pre>
  
  <p>This returns <code>FALSE</code>, which could be one of the reasons the main function is falling over.</p>
  
  <pre><code>NOW() != "07/10/15"
  </code></pre>
  
  <p>How can I fix this?</p>
  
  <p><code>TODAY() == "07/10/15"</code> which solved that half of the issue</p>
  
  <p>The Function is now finding a match but return the value <code>C3</code> the value with the matched date is <code>F3</code> which is the value I want returning. </p>