Convert dates stored as text to dates (with formula)

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: