View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default


"KL" wrote in message
...


=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")


That sorts by month then day :-)