How to Calculate # of years passed from start date

jcouncil

Hi!

I have a smartsheet tracking active customers including the date contracts were signed. I want to use "Contract Start Date" to calculate "Years Serviced" column with total # of years that have passed between "Contract Start Date" and Today.

Sameer Karkhanis

=ROUNDUP((TODAY()-[Start Date]@row)/365, 1)

If you are not particular about months and ok with rounding off, then you can also use,

=YEAR(TODAY())-YEAR([Start Date]@row)

Sameer Karkhanis

=ROUNDUP((TODAY()-[Start Date]@row)/365, 1)

If you are not particular about months and ok with rounding off, then you can also use,

=YEAR(TODAY())-YEAR([Start Date]@row)

jcouncil

That worked perfectly, thank you!