View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robnsd robnsd is offline
external usenet poster
 
Posts: 13
Default sort by month and date only

Is there a way to sort by month and day only? For example, the field
"Date" is in a format mm/dd/yyyy but I want to sort it only by mm/dd
so that January 1, 2004 comes before October 10, 2003. Does that make
sense?

Robert

1/1
1/2....
2/1
2/2...
3/1
3/2...
etc.