Calculate Year's Past

[John23785]

Hello All - I'm looking to convert many rows within a table to a Year's left equation instead of doing it all by hand. The result should be, 

Year New - 2020 

5 Years before Expiration 

Years remaining - 1 

Year New 2018 

5 Years before Expiration

Years Remaining - (-1)

I have all my years of expiration in a separate box but trying to come up with a simple formula that calculates the years remaining but putting it simply as a 5 years left or -1 years left. Any advice would be appreciated, thank you 

[#2 · Accepted solution]

@John23785 

Like this - change the column names to those used in your table:

=[@[Year New]]+[@[Years Before Expiration]]-YEAR(TODAY())

[#3]

Well done! That did it, many thanks.