Adding months onto a date

Hi sorry I have seen this posted multiple times before but I can't get mine to work.

I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column.

I have tried this formula:

=DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row) + ([Monthly Review Frequency]@row), DAY([Previous Review Date]@row))

However this only works for for dates where the year would not change.

Thank you for your help in advance!

Find more posts tagged with

Calendar View

Formulas

Support

Accepted answers

JPFORDTE

HI Genevieve,

thanks for your help, however the dates weren't very accurate for the next review date. I have figured it out myself however using helper rows!

All comments

Genevieve P.

Hi @JPFORDTE

How about translating the months into days, then simply adding that number of days on to the date, like so:

=[Previous Review Date]@row + ([Monthly Review Frequency]@row * 30)

It won't be exactly on the same day of the month 6 months from that date, but it will translate the year correctly. Let me know if this would work for you!

Cheers,

Genevieve

JPFORDTE

HI Genevieve,

thanks for your help, however the dates weren't very accurate for the next review date. I have figured it out myself however using helper rows!

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.