Forum Discussion

fmiddleton's avatar
fmiddleton
Copper Contributor
Mar 20, 2019

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,...
Excel on Mac
Twifoo's avatar
Twifoo
Silver Contributor
Mar 20, 2019
I noticed an extra closing parenthesis after TODAY. Revise your formula this way:
=TEXT(MONTH(TODAY()),
“mmm”)
  • fmiddleton's avatar
    fmiddleton
    Copper Contributor
    Mar 20, 2019

    Twifoo that's just a typo in my posting, not in Excel.

Resources