View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grosvenor Grosvenor is offline
external usenet poster
 
Posts: 2
Default Using the sort function for a date column where year was not enter

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.