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
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?

 

 

Example

 

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?

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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)

    Capture.JPG

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories