Excel Magic Trick 1195


Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution?

DESCRIPTION

See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some are 2000:
(00:52) Text To Columns: Quick and easy to convert YYMMDD or YYYYMMDD into proper dates. Text To Columns is good if the task is a one-time task.
(02:10) Formula #1: IF, LEFT, RIGHT, YEAR, TODAY and TEXT functions. Formula is good if the data will be refreshed or changed often.
(06:08) Formula #2: DATE, IF, LEFT, RIGHT, YEAR, TODAY and MID functions. Formula is good if the data will be refreshed or changed often.

WORKBOOKS