I'm not even sure this is possible, but is there a formula that will calculate maintenance hours/miles/days in one column?
I know that I can put in a simple C2+30 to get the 30 day date due and D3+100 to get the next 100 hour mileage due. But is there a way that I can tell excel to determine that based on the interval or equipment type instead of changing the formula for each equipment type and having to add 2 columns for date next due and hours next due?
<tbody>
</tbody>
I know that I can put in a simple C2+30 to get the 30 day date due and D3+100 to get the next 100 hour mileage due. But is there a way that I can tell excel to determine that based on the interval or equipment type instead of changing the formula for each equipment type and having to add 2 columns for date next due and hours next due?
Equipment | Interval Type | Date completed | Current hours/mileage | Date/Hours next due |
Air compresser | 30 day | 8/2/18 | ? | |
Golf Cart | 100 Hour | 8/2/18 | 500 | ? |
<tbody>
</tbody>