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