How to sort month dates
 

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.

How to sort month dates
 

Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
--
David Biddulph

"Robert Judge" wrote in message
...
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.

How to sort month dates
 

Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
--
David Biddulph

"Robert Judge" wrote in message
...
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.

How to sort month dates
 

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.

"David Biddulph" wrote:

Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
--
David Biddulph

"Robert Judge" wrote in message
...
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.

How to sort month dates
 

Copy, then Edit/ Paste Special: Values
--
David Biddulph

"Robert Judge" wrote in message
...
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.

"David Biddulph" wrote:

Try a helper column =TEXT(A1,"mm/dd") and sort by that column.
--
David Biddulph

"Robert Judge" wrote in message
...
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.