Invalid Value Error with New Year
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))
Help Article Resources
Check out the Formula Handbook template!