Sorting For Plant List, Sort by Month and Day Only
See Mr Excel and excelisfun use two methods to override the Sort feature’s default Date sorting technique so that we can sort just by month and day and get all the Februarys together, all the Marchs together and so on. Mr Excel uses a Custom List, excelisfun uses the Table Feature, the TEXT function and auto complete. Betsie from Olympia Washington uses Find and Replace feature to change the year for a serial number date!!