mm/dd/yyyy - display only MM
I am trying to get a column that will only show me the Month in text, I am referencing Requested_date (in mm/dd/yyyy format). I am using the formula below and i keep getting #unparseable. What i trying to achieve is the following: Column A [Requested_day] = 04/14/2022 then column C [Month] = April. Any suggestions?
=IF(MONTH(Requested_Date]@row = 1, "January") + IF(MONTH(Requested_Date]@row) = 2, "February") + IF(MONTH(Requested_Date]@row) = 3, "March") + IF(MONTH(Requested_Date]@row) = 4, "April") + IF(MONTH(Requested_Date]@row) = 5, "May") + IF(MONTH(Requested_Date]@row) = 6, "June") + IF(MONTH(Requested_Date]@row) = 7, "July") + IF(MONTH(Requested_Date]@row) = 8, "August") + IF(MONTH(Requested_Date]@row) = 9, "September") + IF(MONTH(Requested_Date]@row) = 10, "October") + IF(MONTH(Requested_Date]@row) = 11, "November") + If(Month(Requested_Date]@row) = 12, "December") + " " + DAY([Requested_Date]@row) + " " + YEAR([Requested_Date]@row)
Best Answers
-
Hi there,
Could you confirm if you want just the month in text, or if you want the day and year also? I see you put "April" in the first paragraph but your formula is adding the day and year at the end, so I want to be sure. You were on the right track, just needed to firm up where your ( and [ symbols go. You also do not want to use the + sign, as you are not adding the months, you are just writing multiple different IF statements.
To just receive the Month in text:
=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December"))))))))))))
To receive the Month in text, Day and year with a comma after the day:
=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December")))))))))))) + " " + DAY([Requested_Date]@row) + "," + " " + YEAR([Requested_Date]@row)
-
it worked with one minor correction, but I was able find it, there was a) in the wrong place
Was
IF(MONTH([Requested_Date]@row = 11), "November"
Now
IF(MONTH([Requested_Date]@row) = 11, "November" - I made it mirror all the other months
Thank you again
-
Oh great, thanks for that! Sorry for the typo, I had it working on my end so I must have altered it somehow. Glad you figured it out and it worked for you!
Answers
-
Hi there,
Could you confirm if you want just the month in text, or if you want the day and year also? I see you put "April" in the first paragraph but your formula is adding the day and year at the end, so I want to be sure. You were on the right track, just needed to firm up where your ( and [ symbols go. You also do not want to use the + sign, as you are not adding the months, you are just writing multiple different IF statements.
To just receive the Month in text:
=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December"))))))))))))
To receive the Month in text, Day and year with a comma after the day:
=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December")))))))))))) + " " + DAY([Requested_Date]@row) + "," + " " + YEAR([Requested_Date]@row)
-
I am just looking to having the Month returned as text only, thanks for your feedback. Let me try your examples
-
it worked with one minor correction, but I was able find it, there was a) in the wrong place
Was
IF(MONTH([Requested_Date]@row = 11), "November"
Now
IF(MONTH([Requested_Date]@row) = 11, "November" - I made it mirror all the other months
Thank you again
-
Oh great, thanks for that! Sorry for the typo, I had it working on my end so I must have altered it somehow. Glad you figured it out and it worked for you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
