title: Excel formula to convert date from dddd mmmm dd, yyyy to dd/mm/yyyy
body: <p>I'm trying to convert a long date in excel from the format of <code>dddd mmmm dd, yyyy</code> <strong>to</strong> <code>dd/mm/yyyy</code> using a formula</p>
  
  <h3>Example:</h3>
  
  <p>Convert the following:</p>
  
  <pre><code>Tuesday August 23, 2016
  </code></pre>
  
  <p>To:</p>
  
  <pre><code>23/08/2016
  </code></pre>
  
  <p>I've tried using substitute and search without any success and as far as I am aware there is no function where I can input as one format and withdraw it as another format, I tried using <code>=Text(A1, "dd/mm/yyyy")</code> too but that doesn't work either.</p>
  
  <p>Any ideas?</p>