In such cases, you would need to convert the text into a date format. Here is a guide on how to convert text to date format in Excel. Step 1: Check the Text Format. Before you begin converting the ...