Date Function

Convert Date typed as string to real date

If you have dates which have been wrongly entered in a wrong format then it appears as text. There could be various ways it could have been entered like

All three are different. formats. Now select the column & start the program. You will get a screen like this.

Now select the exact format in which your data is and let this program convert to real dates. Be very precise in the selection and also ensure that all the data is having the same format.