Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting by month, disregarding the year
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 ? |
#2
|
|||
|
|||
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 ? |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Or: =TEXT(B2,"mm-dd")
Myrna Larson wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
sort dates by day then month, not by year. | Excel Worksheet Functions | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to sort by day and month while ignoring year? | Excel Worksheet Functions |