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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!