Forum Discussion
Sort by date missing
Hi I want to sort by date Newest to Oldest, and Oldest to Newest. They are missing under sort and filter. A-Z and Z-A are available and not missing. How do I fix this?
3 Replies
It depends on where you click. In the screenshots, you see a date range.
But when I click in the text header, Sort displays Sort A to Z and Sort Z to A.
If I click in one of the dates, Sort displays Sort Oldest to Newest and Sort Newest to Oldest...
leannejh Then your "dates" are, in fact, texts. You can check that by using =ISTEXT(...) where you insert the cell reference of a "date" on the dots. When you get TRUE in return, you'll know,
You could use Text-to-columns on the data ribbon to transform the text dates to real (numerical) dates. Exactly how, depends on the format the dates are in. Can you include a screen shot?
TRiny_van_Eekelen This doesn't answer the above question.
