Sort by date missing

[leannejh]

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?

[#2]

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

[#3]

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

[#4]

@leannejh 

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