Convert dates stored as text to dates (with formula)

Please sign up for the course before starting the lesson.

If your dates are not pulling through correctly you may need to use one or more of these formula to convert them to a valid date. As mentioned previously, the benefit of using formula to do the conversion is that you can re use the formula which means you can create templates to clean the data.

Back to: Data cleanup in Excel > Correct Dates