title: Compare dates in Google Spreadsheet
body: <p>I have in a google spreadsheet:</p>
  
  <ul>
  <li>cell A1 contains <code>Wednesday 10 June 2015</code> as date</li>
  <li>cell A2 contains <code>Wednesday 10 June 2015</code> as text (that's the output of a google form, I can't choose the format)</li>
  </ul>
  
  <p>How can I obtain TRUE when comparing these 2 cells?</p>
  
  <p>I have tried</p>
  
  <pre><code>=A1=A2
  </code></pre>
  
  <p>and </p>
  
  <pre><code>=TEXT(A1)=A2
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=A1=DATEVALUE(A2)
  </code></pre>