Sort by date missing

Copper Contributor

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

@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?

T@Riny_van_Eekelen This doesn't answer the above question.


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...