Formula to extract month name is not working

deb_63_hydracor

I'm using the following formula to extract the name of the month (e.g., "May" if there is a "5") but keep getting an "Invalid Data" error.

=IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Month]@row) = 2, "February", IF(MONTH([SLA Month]@row) = 3, "March", IF(MONTH([SLA Month]@row) = 4, "April", IF(MONTH([SLA Month]@row) = 5, "May", IF(MONTH([SLA Month]@row) = 6, "June", IF(MONTH([SLA Month]@row) = 7, "July", IF(MONTH([SLA Month]@row) = 8, "August", IF(MONTH([SLA Month]@row) = 9, "September", IF(MONTH([SLA Month]@row) = 10, "October", IF(MONTH([SLA Month]@row) = 11, "November", IF(MONTH([SLA Month]@row) = 12, "December"))))))))))))

Any assistance would be greatly appreciated!! Thanks!

bisaacs

Hey @deb_63_hydracor,

You should be able to input the formula like this:

=IFERROR(IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Month]@row) = 2, "February", IF(MONTH([SLA Month]@row) = 3, "March", IF(MONTH([SLA Month]@row) = 4, "April", IF(MONTH([SLA Month]@row) = 5, "May", IF(MONTH([SLA Month]@row) = 6, "June", IF(MONTH([SLA Month]@row) = 7, "July", IF(MONTH([SLA Month]@row) = 8, "August", IF(MONTH([SLA Month]@row) = 9, "September", IF(MONTH([SLA Month]@row) = 10, "October", IF(MONTH([SLA Month]@row) = 11, "November", IF(MONTH([SLA Month]@row) = 12, "December")))))))))))), "")

It should work no problem (if the SLA Month is also a Date column)

heyjay

Double check that your date column actually has DATE as property. I modifid the last part of your formula and tested.

=IF(MONTH([SLA Month]@row) = 1, "January", 
IF(MONTH([SLA Month]@row) = 2, "February", 
IF(MONTH([SLA Month]@row) = 3, "March", 
IF(MONTH([SLA Month]@row) = 4, "April",
IF(MONTH([SLA Month]@row) = 5, "May", 
IF(MONTH([SLA Month]@row) = 6, "June",
IF(MONTH([SLA Month]@row) = 7, "July",
IF(MONTH([SLA Month]@row) = 8, "August", 
IF(MONTH([SLA Month]@row) = 9, "September", 
IF(MONTH([SLA Month]@row) = 10, "October",
IF(MONTH([SLA Month]@row) = 11, "November", 
IF(MONTH([SLA Month]@row) = 12, "December", 
""))))))))))))

bisaacs

Hey @deb_63_hydracor,

The SLA Month column, is that a date column or just a text/number column for the month?

deb_63_hydracor

Thanks so both of you!

It turns out that I was getting "Invalid Data Type" if the cell is blank. I have this formula in another column but don't know how to incorporate it into the formula above.

=IFERROR(MONTH([SLA - Effective Date]@row), "")

bisaacs

Hey @deb_63_hydracor,

You should be able to input the formula like this:

=IFERROR(IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Month]@row) = 2, "February", IF(MONTH([SLA Month]@row) = 3, "March", IF(MONTH([SLA Month]@row) = 4, "April", IF(MONTH([SLA Month]@row) = 5, "May", IF(MONTH([SLA Month]@row) = 6, "June", IF(MONTH([SLA Month]@row) = 7, "July", IF(MONTH([SLA Month]@row) = 8, "August", IF(MONTH([SLA Month]@row) = 9, "September", IF(MONTH([SLA Month]@row) = 10, "October", IF(MONTH([SLA Month]@row) = 11, "November", IF(MONTH([SLA Month]@row) = 12, "December")))))))))))), "")

It should work no problem (if the SLA Month is also a Date column)