Nov 07 2022 06:07 PM
Nov 07 2022 09:03 PM
@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?
Aug 31 2023 11:14 AM
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...