Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Formula Help

Chris Parra
edited 12/09/19 in Archived 2015 Posts

Can someone share with me the work around they are using for the following issue?





Start Date 08/01/14


Time I want to add to this date - 14 months


Fomula I want to use


 =DATE(year(08/01/14),month(08/01/14) + 14, day(08/01/14))


Which returns an error because the month value is > 12. In excel it just adds 14 months onto the start date.


Am I missing something for an easy workaround?


  • Brett Evans
    Brett Evans ✭✭✭✭✭✭
    edited 08/25/15

    It's a doable workaround...

    Year Column

    IF(MONTH([Original Date]7) + Increment5 > 12, YEAR([Original Date]7) + 1, YEAR([Original Date]7))


    Month Column

    IF(MONTH([Original Date]7) + Increment7 > 12, MONTH([Original Date]7) + Increment7 - 12, MONTH([Original Date]7) + Increment7)


    Day Column

    DAY([Original Date]7)


    New Date Column

    DATE(Year7, Month7, Day7)


This discussion has been closed.