Formula for adding months onto a date
Hi!
Can someone please help me with a formula to auto calculate the 'Expected Finish' by adding the 'Duration' to 'Actual / Expected Start Date'?
Thanks so much!
This formula is getting an 'invalid data type' error:
=IF((MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1))) > 12, DATE(YEAR([Actual / Expected Start Date]@row) + 1, MOD(MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1)), 12), DAY([Actual / Expected Start Date]@row)), DATE(YEAR([Actual / Expected Start Date]@row), MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1)), DAY([Actual / Expected Start Date]@row)))
Answers

This Formula is leaving an 'INVALID DATA TYPE' error:
=IF((MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1))) > 12, DATE(YEAR([Actual / Expected Start Date]@row) + 1, MOD(MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1)), 12), DAY([Actual / Expected Start Date]@row)), DATE(YEAR([Actual / Expected Start Date]@row), MONTH([Actual / Expected Start Date]@row) + VALUE(LEFT(Duration@row, FIND(" ", Duration@row)  1)), DAY([Actual / Expected Start Date]@row)))

I will dig through my notes and get back to you, but you should be able to find something that you can adapt if you search for "EDATE" here in the Community. There are a few posts floating around where we have built out solutions for adding a variable number of months to a date.

Try taking a look through this thread...
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!