I am trying to sort by date, but I want to drop the year out of the format and just have the dd/mm without the yy. I know I can format the cells that way but when I sort it It still sorts it as if the year was a factor. ie
Like the year is there just not visible. As there anyway to just to a true sort without the year as a factor???