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