I'm having an issue with doing a text format conversion on dates. Specifically, if I take a month from a date (returns an integer between 1 and 12) and then do a TEXT command to format as month (Jan, Feb, etc) it always returns "Jan".
e.g. =TEXT(4,"mmm") returns "Jan". =TEXT(MONTH(TODAY()),"mmm") returns "Jan" (and it's March as I write this).
I've tried doing the format as "MMM" also, and get the same response. Returning it as a number (i.e. TEXT(4,"00") gives the expected value "04".
Am I missing something? Running Excel for Mac v16.23 (190309).