What formula do I use to calculate the number of years from a date till today?

sorrymauree

Screen Shot 2023-05-02 at 12.17.39 PM.png

=([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!

Leibel S

@sorrymauree

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)

sorrymauree

Wow. You are a genius!!!!! If I make it a column formula, this formula will apply to every cell?

Leibel S

Yes

sorrymauree

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" ??

Leibel S

That would be simpler, but then if a roof is installed in December, then in January it will already say 1 year old