Calculate years between today and manually input year

LGraf

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.

Thanks.

Paul Newcome

You would replace the hardcoded 1974 with a cell reference.

=YEAR(TODAY()) - [Column name]@row

LGraf

Hi @Paul Newcome, I had considered this but hope there might be another solution since this requires the creation of an additional column in an already crowded sheet. Any other ideas?

Paul Newcome

The only other option would be that they update the formula itself which opens you up to a whole lot of potential issues.

LGraf

Right. Thanks for your help, @Paul Newcome.