View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crackles McFarly Crackles McFarly is offline
external usenet poster
 
Posts: 49
Default Need help sorting DATES please..

I have a large amount of data, it's simply dates.
example
4/4/92
1/3/2007
5/6/1955
etc

I want to display ONLY the month and then SORT only by the month.

Basically I want to ignore the YEAR in the date and then sort.

I've tried this several ways BUT it will not sort the numbers even if
I format them.

help?