Formatting dates with TEXT issue

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,...