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

  • Itai Perez
    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?

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

  • Razetto
    Razetto ✭✭✭✭✭✭
    edited 07/25/23

    @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.

  • @Itai

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

  • Itai Perez
    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.


    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!