View Single Post
  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

Or, if you want to sort by month and DAY, make the formula

=MONTH(B2)*100+DAY(B2)


On Mon, 26 Sep 2005 09:01:18 +0100, "Bob Phillips"
wrote:

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.