Sort by date missing

Occasional Visitor

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?

1 Reply

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