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
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 ExpirationYears 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 Read More