Hi,

First I assume when entering these dates you enter something like 1/4 for 1
April. If you do this Excel will automatically add the current year.

Or possibly a full date has been entered 1/4/2001 and it is formatted to
only show the Day/Month. In either case the year is still there because
formatting doesn't change the underlying value so to sort By day/Month try
this

in a helper column insert the formula
=TEXT(A1,"mmmdd") and drag down
Sort by helper column which you can hide if you want.

Mike

"Grosvenor" wrote:

I have a "Birthday" column in a spreadsheet where only the month/day is
entered. When sorting on this column, the month/day is sorted by the year
the date was entered even though no year was entered. There appears to be a
defaulting setting somewhere, but cannot determined where to adjust the
setting so the column is sorted on only month/year regardless of year
entered.