How to sort month dates

G

Guest

I have a column of many dates in this format, sorted by day/month/year:
December 16, 1900
January 22, 1901
April 14, 1902
July 9, 1903

I would like to sort the dates by month and day and ignore year so the above
data would show as:
January 22, 1901
April 14, 1902
July 9, 1903
December 16, 1900

I will appreciate advice.
 
G

Guest

Thanks. One more question, please. I now want to convert the result
produced by the formula so that I can import it into another program. I
believe there is some EXCEL function so that the result will become fixed
text. I think it is the EXCEL function VALUE, but I cannot remember. So, to
repeat, what I now want to do is convert the result produced by the "helper
column" to an absolute value of that formula. I hope my question is clear,
and I will appreciate further advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rolling time period 4
Transpose Macro 1
How sort dates just by day/month and NOT year if all 3 given in ce 1
sort dates 5
Sort by month, ignore year 7
Sorting dates 1
Convert text to dates 5
sort data by month 2

Top