Correctly

The video addresses a common issue in Excel where dates do not sort correctly by year. The instructor investigates the problem, finding that dates are formatted as text rather than dates. A solution is provided using Excel's 'Text to Columns' feature to correctly format the dates, allowing them to be sorted properly. The video concludes with a verification of the solution, ensuring that dates are now recognized and sorted correctly.

What visual difference did the teacher mention between text and date formats in Excel?

What steps did the teacher take to convert the text to a date format?

How did the teacher confirm that the dates were now recognized correctly?