Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sort just by month when cell says 05/14/1963
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. "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. |
#4
|
|||
|
|||
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. "JR" wrote: 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. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort dates by month rather than by year? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
HELP with this function | Excel Worksheet Functions | |||
i want to display the month from a date into another cell | Excel Worksheet Functions | |||
How do I sort a birthdate list by month then day regardless of ye. | Excel Discussion (Misc queries) |