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")))))))))))), "")
Answers
-
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)
Sincerely,
Jacob Stey
-
Got it! That worked - thank you so much!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
