FORMULA TO PRESENT THE MONTH (NAME) IN A CELL

Options
Rick Girard
Rick Girard ✭✭✭✭✭
edited 09/11/23 in Formulas and Functions

I created a formula using -MONTH to extract the Month Number, but i want that number to convert to the name (JAN, FEB, etc)

I started with pulling the Month Number from the Intake Date column;

=MONTH([Intake Date - \[Select Date\]]@row)

then, I used an =IF to convert the "1" to equal JAN:

=IF(Month1 = "1", "JAN")


I thought i could use an OR statement (multiple times) to name other months beside "1" (ie. "2"=FEB, 3=MAR...etc)

I tested it with a simple additional month number "2" , but it doesnt work.

=IF(OR(Month1 = "1", "JAN", (Month1 = "2", "FEB"))

Looking for guidance here so i can name each of the 12 months for the relative number value provided.


thank you!

Best Answer

  • Rick Girard
    Rick Girard ✭✭✭✭✭
    Answer ✓
    Options

    Hey Andree'

    Thank you for your input, while i was waiting on a reply, i found this to work for me:

    =IF(Month1 = "1", "JAN", IF(Month1 = "2", "FEB", IF(Month1 = "3", "MAR", IF(Month1 = "4", "APR", IF(Month1 = "5", "MAY", IF(Month1 = "6", "JUN", IF(Month1 = "7", "JUL", IF(Month1 = "8", "AUG", IF(Month1 = "9", "SEP", IF(Month1 = "10", "OCT", IF(Month1 = "11", "NOV", IF(Month1 = "12", "DEC"))))))))))))


    I did check you string, i got INVALID DATA TYPE, but i think it would work, i may have not lined up the month@row correctly.


    I'm good to go tho and thanks again!

    Rick

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!