Month Name written as Text for Today's Date

Sam Bottrose

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

John C Murray

Nested IFs are useful when you need the full month (eg. January) because they are all different lengths.

But for three digit abbreviations you can use a much simpler formula:

=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

Sam Bottrose

Get month name in smartsheet

6/1/2020

Month = JUN

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

Genevieve P.

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

=MONTH(TODAY())

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?

Cheers,

Genevieve

Jamie Capito

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

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())

So:

=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?

Cheers!

Genevieve

John C Murray

Nested IFs are useful when you need the full month (eg. January) because they are all different lengths.

But for three digit abbreviations you can use a much simpler formula:

=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

Joe Calderazzo

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.