Formula for adding months onto a date

HBHB

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)))

HBHB

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)))

Paul Newcome

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.

Paul Newcome

Try taking a look through this thread...

https://community.smartsheet.com/discussion/66572/what-is-formula-edate-from-excel-in-smartsheet