Date Formula Error: Invalid Value


I'm trying to +/- months from a date, but I receive "invalid value" whenever there's a change in "year".


=DATE(YEAR(date12), MONTH(date12) + 6, DAY(date12))

If Date is 12/31/2020, then it creates an error because the new date needs to be in 2021 (6 months from 12/31/2020)

How can I fix this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!