I have a sheet where my goal is to remind users when they need a brake change, oil change, tire rotations, etc.
In one column I have the “reminder type,” which tells of what they want to be reminded of and the recommended miles it needs to be changed (25k-50k miles, etc.)
In another column I have the date they last completed the brake change, oil change, tire rotations, etc.
Finally, I have the column where they tell me how much driving they do (10-40 miles/day).
What I need: If a person drives 10-40 miles per day (column H) and they select “brake change” (column E) and tell me they last changed it 9/21/19 (column F), I need the “Reminder date” (column G) to automatically calculate.
Here’s the math:
40 miles/day x 7 (days) x 4 (weeks) x 24 (months) = 26,880 miles driven. Therefore they’ll get a text reminder saying they should get a brake change. This math would carry on for any of the other reminders.