Ironically AI would probably work ok here whereas excel is using a human-designed pattern matching heuristic that apparently either has a bug or didn’t take into account your locale properly. I say that as someone with a relatively negative opinion of ai

This is a task ai would do well at whereas most of the Excel workflow it would not.

It’s actually because January is also misspelled. Or possibly because Excel’s language/region isn’t set up right (I see your month abbreviations aren’t us-eng… If excel is in us-eng it likely isn’t going to identify them properly.