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
-
How exactly are you indicating how many years it should be set out?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!