Thread
:
sort dates by day then month, not by year.
View Single Post
#
5
KL
Posts: n/a
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 With Quote