SOLVED

# Calculate Year's Past

Copper Contributor

# Calculate Year's Past

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 Replies
best response confirmed by John23785 (Copper Contributor)
Solution

# Re: Calculate Year's Past

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

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

# Re: Calculate Year's Past

Well done! That did it, many thanks.
1 best response

Accepted Solutions
best response confirmed by John23785 (Copper Contributor)
Solution

# Re: Calculate Year's Past

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

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