How to auto calculate dates
This works if the contract term is 3 years then End Date but it won't work if the contract term is another number. How do I make it auto calculate if the contract term is 1, 2, 3 or 5 years?
Thanks!
Wina
Best Answer
-
Hi, @WinaHath .
Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".
In your original formula, replace "3" with
[Contract Term (Years)]@row
.Your updated formula will be
=DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row))
.
Answers
-
Hi, @WinaHath .
Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".
In your original formula, replace "3" with
[Contract Term (Years)]@row
.Your updated formula will be
=DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row))
. -
THANK YOU SO MUCH!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!