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
Check out the Formula Handbook template!