Sorting dates by year, not month

Posted by Lisa on August 30, 2001 11:19 AM

Hi all! I'm having a hard time understanding Custom Sorting Order so that I can sort a list of information with dates (dd/mm/yyyy)by the year, not the month. Can anyone shed some light?

Thanks much!

Posted by Barrie Davidson on August 30, 2001 11:21 AM

See
29178.html
and use =Year(A1), not =Month(A1)

Barrie

Posted by Lisa on August 30, 2001 11:33 AM

Barrie,

Sorry, I don't get it. I'm getting funky dates now. Can you "spoon feed" me the steps?

Thanks!
Lisa

Posted by faster on August 30, 2001 11:54 AM

In a blank column insert =Year(Cell#), where Cell# is
the cell that contains the date you want to sort.
You are just extracting the year from the date.

Posted by Barrie Davidson on August 30, 2001 1:04 PM

Lisa, if your data is in column A, then put the formula in B1 and copy it down to the end of your data. Then, perform your sort on column B instead of column A.

Does this help?

Barrie

Posted by Lisa on August 31, 2001 6:49 AM

Yes, thank you. I thought at first that I was changing my original data. Appreciate the help!