Tally Number of Years with a Starting Date

edited 12/09/19 in Smartsheet Basics

I'm new to SmartSheets, so be gentle frown.  I want to insert a formula that will automatically tally a number of years from a given start date every year.  

Example:  I want to know the number of years a person has been in a given rank.  I have the rank date set at 8/16/17.  Every year on 8/16, I want to automate the column by adding another year to their rank.

Suggestions welcome!




appointed to rank and years in rank.PNG