How to add 4 months to a date

Hi there,

I'm trying to figure out when the 4, 8, & 12 month reviews are due for my staff.

I have this formula: =DATE(YEAR([Start Date]@row), MONTH([Start Date]@row) + 4, DAY([Start Date]@row))

BUT it only works within the year, so if someone starts in November, it will not work (obviously as we are adding 4 months, but keeping the year and the day the same)

What I would like to see is this:

Start Date | 4 month Date | 8 Month Date | Annual Review

8/10/2020 | 12/10/2020 | 4/10/2021 | 8/10/2021

Find more posts tagged with

Accepted answers

All comments

Itai Perez

Hey @AlexTrottier

Do you need the dates to accurate? as in 8/10 and then 12/11 or 12/12 is not good enough?

Razetto

@AlexTrottier The problem happens when the month lands on Sept and the following ones. You can create a formula that will use January as the new month instead of adding 4 to Sept, the same if it is October then use February as the month instead of adding 4 to Oct. And the same goes for the year if it's one of those months, Sept-Dec, then use the following year.

AlexTrottier

@Itai

no 8/10 and then 12/11 or 12/12 would work - what would the formula for that look like?

Itai Perez

Hey @AlexTrottier

Its not perfect in a ny way and I am sure some people might have a more accurate solution but I just added 120 to the previous date.

It will miss by a few days a year but it is very simple.

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.