ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sorting dates (https://www.excelbanter.com/excel-worksheet-functions/5351-sorting-dates.html)

Herb October 29th 04 11:15 PM

Sorting dates
 
I want to sort dates by month and day while ignoring the year. Is there a
way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004



Peo Sjoblom October 29th 04 11:20 PM

Only by using a help column and sort by that column

=MONTH(A2)

assuming your data starts in A2, copy down and sort

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Herb" wrote in message
...
I want to sort dates by month and day while ignoring the year. Is there a
way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004




Frank Kabel October 29th 04 11:23 PM

Hi
in a helper column enter the formula
=TEXT(A1,"MMDD")
and sort with this helper column

--
Regards
Frank Kabel
Frankfurt, Germany


Herb wrote:
I want to sort dates by month and day while ignoring the year. Is
there a way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004


Herb October 30th 04 01:22 AM

Thank you very much.

"Frank Kabel" wrote in message
...
Hi
in a helper column enter the formula
=TEXT(A1,"MMDD")
and sort with this helper column

--
Regards
Frank Kabel
Frankfurt, Germany


Herb wrote:
I want to sort dates by month and day while ignoring the year. Is
there a way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004





All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com