title: Excel convert text (April 1, 2017) to date
body: <p>I have some dates in my Excel spreadsheet that are in this format to change it to convert to a date format of <code>dd/mm/yyyy</code>, or any form that allows me to sort by date.</p>
  
  <p>How would I be able to do this using a formula? <code>April 1, 2017 = 01/04/2017</code></p>
  
  <p>Thanks!</p>
  
  <p>P.s. I've looked through the question: <a href="https://stackoverflow.com/questions/36011173/how-to-convert-the-text-to-date-format-in-excel">How to convert the text to date format in excel</a>
  It looked similar, but the formula doesn't work even when I take out the timevalue portion. </p>