Sort "mm-dd-yyyy" by year

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?
 
Munchkin said:
Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?
Click to expand...
 
<What is shown is not what the value of the cell is.>

Unless you entered the dates as text
 
Back
Top