Display Year in a 10-Year Cycle


I have a sheet that is used to track where a store is at in a remodel cycle. Currently, I just have a column that takes the later date of two date columns, and adds ten years for an estimated remodel date. I'd like to add another column that displays the year in that 10-year cycle.

In this sheet the Future AF column takes the earlier date, and adds 10-years. Row 1 takes Latest BIR because that's the earlier date. The AF Counter displays 2, because we are in the 2nd year in the 10-year cycle. 2020 - 2018 = 2.

Can anyone assist with figuring out this formula to display this counter accurately? If a Next AF date is not available, it should read "Missing Data".

Thank you


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!