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)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives