Why Don't My Dates Sort Correctly? | Excel Dates Won't Sort - Oldest to Newest or Newest to Oldest

Описание

Download the featured file here: https://www.bluepecantraining.com/why-dont-my-dates-sort-correctly-excel-dates-wont-sort-oldest-to-newest-or-newest-to-oldest/

In this video I look at why dates won't sort correctly. Dates won't sort correctly when they are stored as text. The first indication that you are in trouble is when Excel offers to sort dates as A to Z or Z to A.

The solution is to convert dates to numeric values and this can be done using Text to Columns.
------------------------