Calculate years between today and manually input year


I would like to calculate years of experience using today's date so that the output automatically updates when the year changes. The following formula does so successfully: =YEAR(TODAY(0)) - 1974. This results in a calculation of 49 since 2023 - 1974 = 49. And, when the year changes to 2024, and beyond, the output will also automatically update because of the TODAY function.

Is it possible to setup a sheet in such a way that the formula is locked in place and the user only inputs the year? For example, the user clicks on the cell and enters "1974", which then runs through the formula.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!