Invalid Value Error with New Year

Options
kmcdonald
kmcdonald ✭✭
edited 12/09/19 in Formulas and Functions

Hello!  I have created a formula for 4 months after a specified date column.  The problem is, when that 4 months goes into next year, I receive the "#INVALID VALUE" error.  For example, if my formula is using the date of 08/31/19, I receive the proper formulated response of 12/31/19...but if I change the date to 09/01/19, I receive the Invalid Value error (that should give the formulated response of 01/01/20 but changing years is when I receive the error). 

Anybody know how to fix this?  This is my formula:

=DATE(YEAR([ECM Implementation]34), MONTH([ECM Implementation]34) + 4, DAY([ECM Implementation]34))     

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!