why can't I sort this by internment date

when I try to sort this by internment date, it won't do it.  What is wrong?
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Ejgil HedegaardConnect With a Mentor Commented:
Some of the dates are not dates, but from row 2022 down it is text that looks like dates.
In Excel I would select the range A2:A3355 and use text to column.
Then it will be converted to dates, except the last 3, where the day value is 0.
Then you can sort.
All Courses

From novice to tech pro — start learning today.