Sorting on month and day portion only of YMD column

New LibreOffice user transitioning from Excel, requesting guidance please.
Have searched, not found the answer. So maybe I also or instead need help on searching?
Worksheet imported from Excel. One column has dates, formatted as mmmm dd yyyy. Another column extracts the month and day part of that column, formatted as mmmm dd. Trying to sort on that column, but it sorts the mmmm alphabetically. How do I sort the column by month number but retain the mmmm formatting?
Thanks.

month_day_sort.ods (15.8 KB)

1 Like

Formated as, or as text? (Ctrl+F8: if cell content is shown in black is text)
What do you see in the formula bar when selecting one of those cells?