How to sort month dates

R

Robert Judge

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.
 
R

Robert Judge

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

Mapping strings to integers 6
Month days over a time period 5
Percentage of month passed formula 1
Problem formatting dates from CSV file 2
15 minute data to daily data 1
Counting Months to get an Average 3
Loop Macro to edit Date 0
Excel PRICE function: How does it compute Issue Date of the Security 5

Top