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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!