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