How to add 4 months to a date

AlexTrottier

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

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.