title: VBA: max Date from string
body: <p>How can I get MAX date from string with multiple date values and different characters?</p>
  
  <p>Example of a string:</p>
  
  <blockquote>
    <p>11AUG2016 Changed gggqqq2i8yj 29SEP2016 Removed tyijdg298 30SEP2016 Added ,mkdjenb200 03OCT2016 zzxxddd4423 04OCT2016 jioi==++-234jju 24OCT2016 Updated tuiomahdkj 10JAN2017 Updated zzzz T4123III 13JAN2017 Updated jukalzzz123 20JAN2017 iiiwwwaazz678uuh</p>
  </blockquote>