title: compare extracted date with today() in excel
body: <p>Column 1 : I have this date-time format in one column = <code>2018-10-08T04:30:23Z</code></p>
  
  <p>Column 3 : I extracted date with formula = <code>=LEFT(A11,10)</code> and changed column format to date.</p>
  
  <p>Column 32 : <code>today()</code>. Just to make sure both date columns match</p>
  
  <p>Now when I want to compare both dates</p>
  
  <p>Column 4 : <code>=IF(C11=D11,TRUE(),FALSE())</code></p>
  
  <p>It does not work. What did I do wrong?</p>
  
  <p><a href="https://i.stack.imgur.com/bkTws.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bkTws.jpg" alt="enter image description here"></a></p>