Supposing your locale is accepting the D/M/Y pattern for dates and one of your dates is in A1, you may enter in a cell of a helper column one of the formulas =VALUE("1/"&A1) or =TEXT(VALUE("1/"&A1),"YYYY/MM"), the first one returning an actual date characterizing the month (first day of), and the second one returning a text describing the month in a passably reasonable format. In both cases the results can be used for sorting.
(Prefer formats according to ISO 8601. Do not use 2-digit-years; there are still dates from the 20th century in the world. Generally don’t use “smart” formats. They may turn out to be silly.)
Edit1:
From the comment by @terry10k I have to conclude that he not actually used the formula I had suggested. With “2/12” e.g. in cell A1, the expression "1/"&A1 on the parameter position would evaluate to "1/2/12" and this accepted under the pattern D/M/Y by the VALUE function would result in 2012-02-01 (formatted in compliance with ISO 8601). For no locale I can think of it would evaluate to a date of the current year.
The month designators given in the OP were texts as terry10k stated. If being numeric (as paul1149 seemingly assumed) and formatted using the number format code “M/YY” they would have sorted correctly anyway.
For texts built from digits to sort correctly, it is indispensable that they comply with four conditions:
(1) They must be accepted under the same strict syntax.
(2) More significant parts must be left of less significant parts.
(3) Delimiters in the respective position must be identical.
(4) The number of digits used for a semantic part must always be the same.
Thus month designators in text form complying with the format code YYYY/MM will sort correctly. Built along the code M/YY they will sort wrongly.
Our remaining problem now is to convert badly formatted designators to wellformed ones. Unfortunately this is not quite simple, and the most simple ways will depend on the locale and/or certain user settings. For more details see the attached example.
(Isn’t it ridiculous how we have to struggle because someone was too lazy to enter a few characters sensibly?)
lof67456SortingMonthDesignators001.ods
