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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!