How can you sort dates based on year rather than by month??

[BRIZZLE1]

Trying to sort dates based on year, rather than by month or day. All dates are in one column and I'm trying to avoid separating into multiple columns as I am constantly adding new information to the document. That said, I am really hoping there is an easier way to sort them by year, without needing to separate the dates into different columns.

Sorting by A or Z only sorts based on month, so need to figure out how to sort rows based on one of the columns date, but paying attention to the year as the sorting factor.

Thank you so much in advance,

Bryan

 

[BRIZZLE1]

even though this doesn't solve my current challenge, I figured this is something still very cool that I want to learn. that said, few things:
1. I think I'm missing the step to get the dates back into one column, and how the comma gets inserted (or when)
2. when I do the text to column, instead of it doing as expected, some of the months get split in the middle of the actual month, so november might be novem ber (separate columns) AND many of the cells now show fractions within the cell.... no idea why and have never seen something like this before.

 

[Nalani]

. All dates are in one column and I'm trying to avoid separating into multiple columns as I am constantly adding new information to the document.

Bryan

As your first post says, all dates are in one column. Is this not the case?

If they are, then you may have not followed the Text to Columns instructions correctly.

Data > text to columns > Next > Next > under "column data format" select "date" and then the "source format"...I'm guessing MDY > Finish

Where it says Next, do nothing except press the Next Button.

If you download one of the links in my signature block at the bottom, you can post a sample of your data.

 

[BRIZZLE1]

Janie, I did exactly as instructed and didn't work. I have a MAC, so looks like I can't use your link properly. Thank you for the suggestion though.

 

[Nalani]

I'm not familar with Mac's. But there are others on this Board who use Mac's.

Maybe one will come along.