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

Employee

• ✭✭✭

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

• ✭✭✭

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.

• ✭✭✭

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

• ✭✭✭
edited 08/23/24

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!