How to sort just by month when cell says 05/14/1963

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
One way;
In a helper column enter =month(A1) assuming that A1 contains the date. Copy
dowm and sort on the new column
HTH
 
You can just highlight all of your data (b-day, emp name, emp dept, etc.) and
sort (ascending) by the b-day column. Dates have a serial number associated
with them so, 04/01/05 is less than 05/01/05. This will put them in day
order as well but, all of April will be together, all of May will be
together, etc.
 
JR
That works fine if you want to sort by date. In this case DKR was trying to
identify everyone with a birthday in May no matter what the year of birth. By
using the =month() function you can isolate and then sort on the month only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort by month on pivot report 4
Sorting date fields by month excluding year 1
how do I sort dates by months? 2
sorting dates in a worksheet 3
Date / month trouble 3
Sort dates Excel 2007 1
How do I sort a list of dates in Excel by month and day? 3
sort by month out of sequence 4

Back
Top