I am trying to calculate the next future invoicing date given an initial renewal date and a increment time (given in months) without using Google scripts or VBA. I have already spent an unreal amount of time trying to do this in Excel with and without VBA but to no avail. Ideally I would like to move this all to Google Sheets but I don’t want to deal with having to deploy custom scripts so anybody could use it. With that said if somebody knows how to do it in either Google Sheets or Excel I would greatly appreciate your input!
Example - Assuming today's date is 8/5/2024 but this should
reflect the updated current date, not a static or hardcoded date.
StartDate | Increment (months) | Result
7/14/2024 1 8/14/2024
7/2/2024 1 8/2/2024
7/14/2016 12 7/14/2025
7/14/2022 6 2/14/2025
I have had so much trouble finding information on this question that I figured a SO post would be appreciated by anybody with the issue.