Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple.
I'm trying to add a certain number (Varying) of months to a start date to produce an end date.
I have a start date column (which is a date column), a column that has the number of months (they're drop down options), and then I'm trying to produce the end date after so many months have passed.
I found this solution/excel formula on a website:
It appears that it should work, but it does not work when I try it in Smartsheet. I believe it may be because my date format isn't what's needed for this type of formula. So now I'm tasked with trying to re-format the date column (using a helper column) into a format that will allow me to use the above formula. Can someone help me with this?
Help Article Resources
Check out the Formula Handbook template!