Forum Discussion
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
Like this - change the column names to those used in your table:
=[@[Year New]]+[@[Years Before Expiration]]-YEAR(TODAY())
Like this - change the column names to those used in your table:
=[@[Year New]]+[@[Years Before Expiration]]-YEAR(TODAY())
- Well done! That did it, many thanks.
