Excel Magic Trick 1255

DESCRIPTION

Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates
Learn how to Convert Text Dates With Missing Year & Extra Spaces To Real Dates (Serial Number Dates) with a formula that uses the TRIM, IF, ISNUMBER and SEARCH functions.

WORKBOOKS