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???

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???

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???

"KL" wrote in message
...


=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")

That sorts by month then day :-)

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 :-)

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 :-)