Help with formula to return month + year from "Date Created" field.

SallyJ

I am trying to create a column formula to return the "Month Year" from a "Date Created" field, with the month fully spelled out.

This is what I have so far, but for some reason it is returning the blank value even though the date created field has a value of "03/01/24 11:13 AM."

Additionally, I need help figuring out how/where to add YEAR([Date Created]@row) to the end of this formula, so that the value returned from the above example would be "March 2024" or "March 24." Thanks!

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

SteyJ

https://community.smartsheet.com/discussion/118404/help-with-formula-to-return-month-year-from-date-created-field

Hi @SallyJ :

The reason it's blank is because the formula has a lot of = marks in it, so the IFERROR returns null (empty)

Here is the correct formula you should be using:

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

SallyJ

Got it! That worked - thank you so much!

SteyJ

https://community.smartsheet.com/discussion/comment/422887#Comment_422887

anytime!