How can I autopopulate end date with months duration without using dependencies?
I am trying to work out how to autopopulate end date of the project based on start date and duration I have in months. I am trying to avoid using dependencies as those do not support months, only weeks, and that is not an exact value. We have several hundred projects running at the same time so really going and checking the duration and adjusting the weeks to approximately match the values is super tedious and multiplication of x months *4 is not precise at all. Let's say, the project starts 1-Jan-2020 and has a duration of 12 months, so the end date should be 31-Dec-2020. I tried using a formula I found here on this forum, on one of my sheets but it comes up as an invalid argument:
=IFERROR(DATE(YEAR([Start Date]1, MONTH([Start Date]1 + [Duration (months)]1, DAY([Start Date]1)), DATE(YEAR([Start Date]1 + 1, MONTH([Start Date]1 - [Duration (months)]1, DAY([Start Date]1)))))))
Any help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!