If your dates are not pulling through correctly you may need to use one of these tools to (quickly) convert them to a valid date. As mentioned previously, using one of the inbuilt tools is great when you just quickly want to get Excel to ‘see’ the date.
Convert dates stored as text to dates (with tools)
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.