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

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")))))))))))), "")

Find more posts tagged with

Accepted answers

All comments

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!

rshelnutt

I came here with the same question and your formula worked perfectly for my sheet as well. Thank you!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.