Date Formula Issue: #Invalid Value
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)), "")
Answers

You could just add 30.437 days/month, or 91.3 days for three months. Then you simply add 91.4+A1.

Thank you for getting back to me so quickly. This is my first time using these kinds of formulas. Can you tell me where I add your changes into the current formula?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!