Need Help Resolving #UNPARSEABLE Error in Date Formula for Invoice Month and Year
Best Answer
-
Hello @akarlsson
It looks as if you may have forgot the parenthesis around your [Invoice Date]@row for your MONTH functions.
Try this:
=IF(MONTH([Invoice Date]@row) = 1, "January", IF(MONTH([Invoice Date]@row) = 2, "February", IF(MONTH([Invoice Date]@row) = 3, "March", IF(MONTH([Invoice Date]@row) = 4, "April", IF(MONTH([Invoice Date]@row) = 5, "May", IF(MONTH([Invoice Date]@row) = 6, "June", IF(MONTH([Invoice Date]@row) = 7, "July", IF(MONTH([Invoice Date]@row) = 8, "August", IF(MONTH([Invoice Date]@row) = 9, "September", IF(MONTH([Invoice Date]@row) = 10, "October", IF(MONTH([Invoice Date]@row) = 11, "November", IF(MONTH([Invoice Date]@row) = 12, "December")))))))))))) + " " + YEAR([Invoice Date]@row)
Hope this helps!
Davin Vo - Sevan Technology
Smartsheet Platinum Partner
Answers
-
I tried this formula with some modifications for my sheet and I am still getting #UNPARESABLE. The formula I used is:
=IF(MONTH[Invoice Date]@row = 1, "January", IF(MONTH[Invoice Date]@row = 2, "February", IF(MONTH[Invoice Date]@row = 3, "March", IF(MONTH[Invoice Date]@row = 4, "April", IF[Invoice Date]@row = 5, "May", IF(MONTH[Invoice Date]@row = 6, "June", IF(MONTH[Invoice Date]@row = 7, "July", IF(MONTH[Invoice Date]@row = 8, "August", IF(MONTH[Invoice Date]@row = 9, "September", IF(MONTH[Invoice Date]@row = 10, "October", IF(MONTH[Invoice Date]@row = 11, "November", IF(MONTH[Invoice Date]@row = 12, "December")))))))))))) + YEAR([Invoice Date]@row)
The Invoice Date column is a DATE column type. Format is MM/DD/YY.
Any advice?
-
Hello @akarlsson
It looks as if you may have forgot the parenthesis around your [Invoice Date]@row for your MONTH functions.
Try this:
=IF(MONTH([Invoice Date]@row) = 1, "January", IF(MONTH([Invoice Date]@row) = 2, "February", IF(MONTH([Invoice Date]@row) = 3, "March", IF(MONTH([Invoice Date]@row) = 4, "April", IF(MONTH([Invoice Date]@row) = 5, "May", IF(MONTH([Invoice Date]@row) = 6, "June", IF(MONTH([Invoice Date]@row) = 7, "July", IF(MONTH([Invoice Date]@row) = 8, "August", IF(MONTH([Invoice Date]@row) = 9, "September", IF(MONTH([Invoice Date]@row) = 10, "October", IF(MONTH([Invoice Date]@row) = 11, "November", IF(MONTH([Invoice Date]@row) = 12, "December")))))))))))) + " " + YEAR([Invoice Date]@row)
Hope this helps!
Davin Vo - Sevan Technology
Smartsheet Platinum Partner
-
Yep, you were right! @Davin Vo. Thanks! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!