Try:

=text(B2,"mm/dd")



MMangen wrote:

I rec'd a "value" error!

"~L" wrote:

If the birthday date is in column B:

=text(B2,mm/dd)

Will produce results that will sort by month.

"MMangen" wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

--

Dave Peterson