# 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!

Tags:

## 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!