When this happens, use the DATEVALUE function to convert the text dates to Excel serial numbers. To test this function, enter five dates—as text—in cells A5 through A9.