Future Date Calculation Formula

I have a sheet where we are trying to track the date a reminder needs to be sent for certain inspections. Some inspections are annual, some are every 5 years and some every 10 years. For the annual inspection items I have one column for the month of the inspection, one column for the day of the inspection, and a column using a formula to automatically recalculate the date when it passes to reset it to that date of the next year.

For those that should occur every 5 or 10 years though I'm struggling to create a formula for those. The years of the previous inspections vary, so one may have been completed in 2020 and next needs to be done in 2025, while another was last done in 2022 and needs to be done in 2027. I have a column with the last inspection date, and I'm trying to come up with a formula to determine when that date has passed, and once it has passed to calculate the new date that is 5 or 10 years in the future.

Any ideas on how to do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!