Forum Discussion
Solved
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 r...
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.
