I have a large list of dates that I need to sort by only the month and day
(e.g. 9/14) and do NOT want or need the year. I had set up a helper column
originally to do the sort but about two weeks ago any date I added will no
longer sort. My formula appears intact (=text(a2,"mm/dd"). I've even tried to
manually enter the date in the helper column which I normally hide but the
date will then appear as "14 Sep". Obviously there is something very simply
staring right at me to correct this but I'm not seeing it.