I am trying to add 5 years to a date

Becky Wilson

I am using the following formula

=DATE(YEAR([Activation Date]@row) + 5, MONTH([Activation Date]@row), DAY([Activation Date]@row))

The Activation Date column is set to a Date column Type

The receiving column (Expiration Date) is also set to a Date column Type

I am getting an error #UNPARSEABLE

Find more posts tagged with

Formulas

Accepted answers

Becky Wilson

This is resolved - Thanks

All comments

Becky Wilson

This is resolved - Thanks

Genevieve P.

I'm glad you were able to resolve this!

Cheers, Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.