How to extract just the month name from a date
Hi all,
I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
Best Answers
-
SIS,
I see that you shortened the month names but yes that looks great.
Hope this helps!
Heath Hilton
-
Nested IFs are useful when you need the full month name, but for three digit month names you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)
Answers
-
SIS,
Here is the formula that I was able to come up with. You would need to have the formula below in the [Month] column.
=IF(MONTH([Shipped Date]@row) = 1, "January", IF(MONTH([Shipped Date]@row) = 2, "February", IF(MONTH([Shipped Date]@row) = 3, "March", IF(MONTH([Shipped Date]@row) = 4, "April", IF(MONTH([Shipped Date]@row) = 5, "May", IF(MONTH([Shipped Date]@row) = 6, "June", IF(MONTH([Shipped Date]@row) = 7, "July", IF(MONTH([Shipped Date]@row) = 8, "August", IF(MONTH([Shipped Date]@row) = 9, "September", IF(MONTH([Shipped Date]@row) = 10, "October", IF(MONTH([Shipped Date]@row) = 11, "November", IF(MONTH([Shipped Date]@row) = 12, "December"))))))))))))
Here is what it exports on the sheet.
Let me know if it helps.
Hope this helps!
Heath Hilton
-
Thanks,
Thanks so much, Heath! I was trying that formula and was getting an error! What is your thought on the formula I'm trying? it is a workaround based on yours.
-
SIS,
I see that you shortened the month names but yes that looks great.
Hope this helps!
Heath Hilton
-
How does the formula works if the Shipping date is empty and the formula need to refer to another date field with the same changes from "Month Number -> Month Name".
e.g. use MONTH from [field 1]@row and change it to Name, if error use MONTH from[ field2]@row and change it to Name.
KR Christin
-
Hi @Christin F.
You can add an IFERROR statement around the first MONTH function to evaluate if the cell is blank or not. If it is blank, have it look at your second column instead:
=IF(IFERROR(MONTH([field 1]@row), MONTH([field 2]@row)) = 1, "January",
And so on. Does that make sense?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Nested IFs are useful when you need the full month name, but for three digit month names you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!