Forum Discussion
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,...
I noticed an extra closing parenthesis after TODAY. Revise your formula this way:
=TEXT(MONTH(TODAY()),
“mmm”)
=TEXT(MONTH(TODAY()),
“mmm”)
Twifoo that's just a typo in my posting, not in Excel.