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

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.

--
HTH

Bob Phillips

"Soffi" wrote in message
...
I have a list of names in one column, and their date of birth in another
column.
I want to sort day and month, disregarding the year, in order to see who

has
a birthday this month. But how ?