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

Find more posts tagged with

Accepted answers

All comments

HBHB

This Formula is leaving an 'INVALID DATA TYPE' error:

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.