title: Automatically convert date text to correct date format using Google Sheets
body: <p>I'm trying to convert date from "text" to correct format. It is logged to Google Spreadsheets and I'm unable to use it to plot graphs.</p>
  
  <p>This is the text format: <code>February 3, 2018, at 11:21 AM</code></p>
  
  <p>Time is not relevant, all I need is the date converted: <code>DD/MM/YYYY.</code></p>
  
  <p>I found a similar question where Gary's Student answered with a formula that looks like this for a different format:</p>
  
  <pre><code>=DATEVALUE(SUBSTITUTE(A1,MID(A1,FIND(" ",A1)-2,2),""))
  </code></pre>
  
  <p>(<a href="https://stackoverflow.com/questions/38634547/convert-text-date-format-to-date-format">link to that question</a>)</p>
  
  <p>How can I use above formula (or something similar) so that text is converted to date?</p>
  
  <p>Thanks in advance.</p>