title: Extract dates in various formats from free text string in excel
body: <p>I'm struggling with extracting dates from a free text field in Excel where the date could be in any number of formats due to human input.</p>
  <p>Some examples of the entries are below but essentially they could be 30/6, 30/06, 30th June, 30/6/21, 30/06/21, 30/06/2021, 30-6, 30th, 30-06, tomorrow!</p>
  <p>Alright; I probably can't do much about that last one and I can pull the date from the others if I know the format but I'm looking for something that would handle any and all of the permutations.</p>
  <p>Example Data</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column A</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Empire still haven't repaired the roof. Waiting on Empire to waterproof the roof then I can patch up the ceiling in 611. ETA  30/06/2021</td>
  </tr>
  <tr>
  <td>ETA 11/6/21</td>
  </tr>
  <tr>
  <td>floor boards need replaced</td>
  </tr>
  <tr>
  <td>22/6/21 awaiting parts</td>
  </tr>
  <tr>
  <td>have sanded the filler that was in the war and refilled ready for or sanding again</td>
  </tr>
  <tr>
  <td>new bathroom floor to replace. need to source materials and have time to do job. full bathroom sub floor to replace. ETA 29/06</td>
  </tr>
  <tr>
  <td>Engineer attended and found E122 error, reset and tested but fault still present. New EVA probe required. Part to be sent to site.</td>
  </tr>
  <tr>
  <td>new toilet handle ordered. ETA 28th June</td>
  </tr>
  <tr>
  <td>TV on order</td>
  </tr>
  <tr>
  <td>refer to Colin Warner for further works and required parts</td>
  </tr>
  <tr>
  <td>28/6 awaiting underlay</td>
  </tr>
  <tr>
  <td>leak in room 315 fixed. room 215 will need a week to dry. ETA 30th June.</td>
  </tr>
  <tr>
  <td>10 July</td>
  </tr>
  <tr>
  <td>ceiling too wet to carry out any work. eta 5-07-2021</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I know it's a big ask but if you know of a formula or VBA UDF that can handle all of those then I'd be eternally grateful.</p>