That has a formula that is like:
=DAY(originalDateCell) + (MONTH(originalDateCell) * 100))
Need help on sorting my dates by month/day and not year. Can someone help me?
![]() | 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 |
Need help on sorting my dates by month/day and not year. Can someone help me?
Discussion is locked
That has a formula that is like:
=DAY(originalDateCell) + (MONTH(originalDateCell) * 100))
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
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