I have a date. 1/1/2019. I can reference the cell and extract the date using =month(A1). It'll show as a 1.
Is there a way to show that as Jan, but also have excel read it as a month? So when I filter on the column, the months aren't in alphabetical order, they are instead in order of the calendar.
Currently, everything I have tried excel wants to put it in alphabetical order.
Thanks
Bookmarks