Date Formula Issue: #Invalid Value

CWilliam ✭✭
edited 10/26/21 in Formulas and Functions

I am a complete novice and I have been tasked with fixing someone else's formula. I have seen a number of responses to similar problems with other people but their solutions are not working for me. My formula is supposed to calculate a date 3 months later. For example, in column 1 the date is 10/01/2021. In column 2, the date should read 01/01/2022. However, the formula is defeated by the year change. Can anyone help me? Here is the current formula:

=IF([Assign Date]@row <> "", DATE(YEAR([Assign Date]@row), MONTH([Assign Date]@row) + 3, DAY([Assign Date]@row)), "")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!