What formula do I use to calculate the number of years from a date till today?
=([Roof Install Date]@row - TODAY ()) / 365
I want this to be automatically calculated, but the formula posted on another post does not work. Please let me know how I can accomplish this.
Thank you!
Answers
-
try the below:
=IF(TODAY() > [Roof Install Date]@row, (IF(DATE(YEAR(TODAY()), MONTH([Roof Install Date]@row), DAY([Roof Install Date]@row)) <= TODAY(), YEAR(TODAY()) - YEAR([Roof Install Date]@row), YEAR(TODAY()) - YEAR([Roof Install Date]@row) - 1)), 0)
-
Wow. You are a genius!!!!! If I make it a column formula, this formula will apply to every cell?
-
-
Leibel,
Is there a way to do this without using a date? And only using "Year"? So I can just put "2018" instead of "05/02/2018" ??
-
That would be simpler, but then if a roof is installed in December, then in January it will already say 1 year old
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!