Need Help Resolving #UNPARSEABLE Error in Date Formula for Invoice Month and Year

System

This discussion was created from comments split from: How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?.

Davin Vo

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!

akarlsson

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?

Davin Vo

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!

akarlsson

Yep, you were right! @Davin Vo. Thanks! :)