What I'll do is convert the date to text (5/9 is now 05/09) and then convert
that back to "date," which seems to work. Except now some of my full dates
(MM/DD/YYYY) appear as "######" in the cells. Wierd.

"Mike H" wrote:

Hi,

Excel is interpreting 3/14 as a date and because you omit the year. Excel
adds the current one, even when you format the cell to show months and days
the year is still there, you just cant see it.

Extract the day and month to a helper column and use that for your sort.

=TEXT(A1,"mm/dd")

Mike

"Excelsior731" wrote:

The date in the cell keeps adding the year when I don't want it to, even if I
select "Category - Date" and "Type - 3/14". I need to have ONLY the month and
day (2 digits each in the date format so it's sortable), not the year, but
the year keeps appearing after the date in the formula bar.