Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort dates by day then month, not by year.
Is there anyway to sort birthdays by day then month not including the year if
it is in this format: 01/05/50? I have tried auto filter, then custom filter but nothing works with that, so then I try to sort but it doesnt sort by day or month only the year. Can you please help me??? |
#2
|
|||
|
|||
Hi Lisa,
You could... 1) create an additional column 2) enter the following formula in the first cell (e.g.B1) of the new column: =TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00") 3) copy the formula down 4) sort using the new column Regards, KL "Lisa Peterson" wrote in message ... Is there anyway to sort birthdays by day then month not including the year if it is in this format: 01/05/50? I have tried auto filter, then custom filter but nothing works with that, so then I try to sort but it doesn't sort by day or month only the year. Can you please help me??? |
#3
|
|||
|
|||
Thank you so much that really helped.
"KL" wrote: Hi Lisa, You could... 1) create an additional column 2) enter the following formula in the first cell (e.g.B1) of the new column: =TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00") 3) copy the formula down 4) sort using the new column Regards, KL "Lisa Peterson" wrote in message ... Is there anyway to sort birthdays by day then month not including the year if it is in this format: 01/05/50? I have tried auto filter, then custom filter but nothing works with that, so then I try to sort but it doesn't sort by day or month only the year. Can you please help me??? |
#4
|
|||
|
|||
"KL" wrote in message ... =TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00") That sorts by month then day :-) |
#5
|
|||
|
|||
Yeah, but I guess it is more logical viceversa :-)
Regards, KL "Bob Phillips" wrote in message ... "KL" wrote in message ... =TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00") That sorts by month then day :-) |
#6
|
|||
|
|||
Agree with you, that is why I added my initial smiley
Regards Bob "KL" wrote in message ... Yeah, but I guess it is more logical viceversa :-) Regards, KL "Bob Phillips" wrote in message ... "KL" wrote in message ... =TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00") That sorts by month then day :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
sort dates by month and day not year | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
How to sort by day and month while ignoring year? | Excel Worksheet Functions |