Month Name written as Text for Today's Date

Sam Bottrose
Sam Bottrose ✭✭
edited 08/22/23 in Best Practice

what function return month name from date "i.e =TEXT(MONTH(TODAY()),"MMM")"?

Best Answer


  • Get month name in smartsheet


    Month = JUN

    equvelant to excel "=TEXT(MONTH(TODAY()),"MMM") "

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Sam,

    The MONTH function in Smartsheet will return a number based on which month is in the date. For example, January is 1.

    So if you entered the formula


    you would get the answer: 6

    Then what we can do with this is use a nested IF statement to tell the formula what text each number should return:

    =IF(MONTH(TODAY()) = 1, "JAN", IF(MONTH(TODAY()) = 2, "FEB" .... etc

    Does that make sense? Do you want a full formula that goes through all possibilities of what the month is?



  • @Genevieve P. if I have this formula here =IFERROR(MONTH(Date@row), "") and it's producing a number..what do I need to do to revise this formula so that it produces the name of the month instead?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Jamie Capito

    The formula will need you to identify the text you want to associate with each individual number. For example, if it returns 1, you need to identify if you want that to say "JAN" (like in my example above) or "January" etc.

    Your formula of MONTH(Date@row) would replace my previous MONTH(TODAY())


    =IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March"... etc

    Then when you're done, wrap the IFERROR around the entire formula:

    =IFERROR(IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March"))), "")

    Does that make sense? Do you need help spelling out all 12 months, or will this be enough?



  • Joe Calderazzo
    edited 09/12/23

    I have found that I use this quite frequently, so I created a helper grid with Month in two formats and the month numbers. Headers are Month, Mon, Num - entered data as January, Jan, 1, February, Feb, 2, etc. and whenever I need to access the month text in either format, I just quickly paste =INDEX({Month}, MATCH((MONTH([Delivery Date]@row)), {Num}, 0)) formula referencing the grid I placed at the top of my Sheets and make that formula a Column Formula.