Sorting dates

Posted by QT on July 18, 2001 1:25 PM

Let's suppose my column A is date (mm/dd/yy). I need to sort by month, then date, and ignoring the year. Thanks for any help.

Posted by JLR on July 18, 2001 1:41 PM

Why don't you break the data up into separate columns. You can click on Data, text to columns, format the appropriate cells to text (its an option in text to columns); then break it up into separate columns. then you can sort however you want.

Posted by FASTER on July 18, 2001 3:43 PM

Use the month and day in separate columns

COLUMN A =TODAY()
COLUMN B =MONTH(A1)
COLUMN C =DAY(A1)