I searched for a solution but couldn't find one. I have an output form system where the dates look like the picture attached. The data is text which I want to convert to a date but no matter what combination of formulas i find none of the get the job done. I'm not sure if its the extra spaces or what. Either way I included text to column converter image to better show how the data looks. Is there a formula that will do the job...thanks.