Thread: Sort By Date, Ignore Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SRBROTZ SRBROTZ is offline
external usenet poster
  
Posts: 1
Default Sort By Date, Ignore Year
I have a need to sort a group of dates, ascending ignoring the year. the list

1/15/1960
1/06/1948
1/21/1980
1/1/1985

would be sorted as

1/1/1985
1/06/1948
1/15/1960
1/21/1980

Can any one help? What is needed to do this?
Reply With QuoteReply With Quote