Excel formula: Convert text to date | Exceljet
In cell C6, we use the LEFT, MID, and RIGHT functions to extract each of these components from a text string, and feed the results into the DATE function: = DATE(LEFT( B6,4),MID( B6,5,2),RIGHT( B6,2)) The LEFT function extracts the leftmost 4 characters for year, the MID function extracts characters in positions 5-6 for month, and the RIGHT ...