Hi,
I have an excel file with domain names, and one of the columns displays their expiry dates in this format: MMM-DD
Now, I want to be able to sort this list by month and day (in THIS order) - so, completely ignoring the year - so I can easily see which domains are approaching renewal date so I can, obviously, renew them. But the problem is that I don't know how to do this godlike-type of sorting, which is why I'm asking you jedi masters of excel
So, can someone help me solve my little sorting issue? Pretty please?
John
I have an excel file with domain names, and one of the columns displays their expiry dates in this format: MMM-DD
Now, I want to be able to sort this list by month and day (in THIS order) - so, completely ignoring the year - so I can easily see which domains are approaching renewal date so I can, obviously, renew them. But the problem is that I don't know how to do this godlike-type of sorting, which is why I'm asking you jedi masters of excel
So, can someone help me solve my little sorting issue? Pretty please?
John