Convert text date to numeric date in Excel

When date is input as text like 20190701, it could be really frustrating as we cannot performance any date related calculation on it.
Luckily we can convert those text dates into numeric dates easily with Text to Columns. Check this out.