View Single Post
  #2   Report Post  
Ray A
 
Posts: n/a
Default

One way;
In a helper column enter =month(A1) assuming that A1 contains the date. Copy
dowm and sort on the new column
HTH

"DKR" wrote:

I have employee birthdates in a column like 05/14/1963, and I need to sort
my month only, I have tried that text to column thing and it doesn't work for
me. Is there a way to sort this by month only so I can get the people who
have a birthday for a particular month. Thanks in advance.