Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Sorting

May 12, 2005 2:05AM PDT

Need help on sorting my dates by month/day and not year. Can someone help me?

Discussion is locked

- Collapse -
Sort on a new column.
May 12, 2005 2:14AM PDT

That has a formula that is like:

=DAY(originalDateCell) + (MONTH(originalDateCell) * 100))

- Collapse -
Excel Sort
May 12, 2005 6:59AM PDT

Name Address 1 Address 2 City St Postal Loc Descr Birthdate
8/5/1963
12/31/1960
3/12/1952


This is how I have the columns setup. With the dates under birthday, and trying to sort that field so that it can have 01(jan), 02(feb), etc., to sort by month/day. I tried your fix, but could not get it to work. Can you help? Thanks

- Collapse -
Re: sorting on dates
May 12, 2005 5:20PM PDT

The suggestion by Bob was perfect, except that the formula had just 1 ) too much at the end, so all I can do is repeat it:

Sort on a new column that has a formula that is like
=DAY(originalDateCell) + (MONTH(originalDateCell) * 100).

You can add this new column next to the birthday column, for example. It will contain numeric values like (in your example) 805, 1231, 312, resulting in a sort sequence 312->805->1231 or 3/12/1952, 8/5/1963, 12/31/1960.

It can't go wrong. Just do as told.

Kees

- Collapse -
Formula Worked
May 13, 2005 3:57AM PDT

Thank you both for assisting me with my sorting. It work prefectly.

Bye

- Collapse -
Cheers!
May 13, 2005 4:18AM PDT

Sorry about the extra parentheses. You can keep it as a reminder I make a lot of typographic errors.

Bob