Excel convert a date string to a date-time value

Because I constantly search for an answer to this, here are a few links:

My latest found guide to building a parser: https://exceljet.net/formula/convert-date-string-to-date-time

I liked this link back in 2012: http://superuser.com/questions/274494/convert-text-string-to-date-time-format

Here's my own 2012 blog post about this with some examples and other useful info: http://arobotatwork.blogspot.com/2012/08/excel-decoding-and-adding-times.html