Calculating Mileage/Days

[debenay]

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?


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Equipment[/TD]
[TD]Interval Type[/TD]
[TD]Date completed[/TD]
[TD]Current hours/mileage[/TD]
[TD]Date/Hours next due[/TD]
[/TR]
[TR]
[TD]Air compresser[/TD]
[TD]30 day[/TD]
[TD]8/2/18[/TD]
[TD][/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Golf Cart[/TD]
[TD]100 Hour[/TD]
[TD]8/2/18[/TD]
[TD]500[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

 

[lrobbo314]

How about this?

<caption>LEGO HTML</caption><colgroup><col style="width: 54px"><col width="152"><col width="142"><col width="156"><col width="189"><col width="180"></colgroup><tbody>
[TH="bgcolor: #A6A6A6"] A [/TH]
[TH="bgcolor: #A6A6A6"] B [/TH]
[TH="bgcolor: #A6A6A6"] C [/TH]
[TH="bgcolor: #A6A6A6"] D [/TH]
[TH="bgcolor: #A6A6A6"] E [/TH]

[TH="bgcolor: #A6A6A6"] 1 [/TH]
[TD="bgcolor: #FFFFFF"] Equipment [/TD]
[TD="bgcolor: #FFFFFF"] Interval Type [/TD]
[TD="bgcolor: #FFFFFF"] Date completed [/TD]
[TD="bgcolor: #FFFFFF"] Current hours/mileage [/TD]
[TD="bgcolor: #FFFFFF"] Date/Hours next due [/TD]

[TH="bgcolor: #A6A6A6"] 2 [/TH]
[TD="bgcolor: #FFFFFF"] Air compresser [/TD]
[TD="bgcolor: #FFFFFF"] 30 day [/TD]
[TD="bgcolor: #FFFFFF"] 8/2/2018 [/TD]
[TD="bgcolor: #FFFFFF"] [/TD]
[TD="bgcolor: #FFFFFF"] 09/01/2018 [/TD]

[TH="bgcolor: #A6A6A6"] 3 [/TH]
[TD="bgcolor: #FFFFFF"] Golf Cart [/TD]
[TD="bgcolor: #FFFFFF"] 100 Hour [/TD]
[TD="bgcolor: #FFFFFF"] 8/2/2018 [/TD]
[TD="bgcolor: #FFFFFF"] 500 [/TD]
[TD="bgcolor: #FFFFFF"] 600 [/TD]

</tbody>

[TABLE="width: 100%"]
<caption>Worksheet Formulas</caption><tbody>[TR]
[TH="bgcolor: #A6A6A6"]Cell[/TH]
[TH="bgcolor: #A6A6A6"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #FFFFFF"]E2[/TH]
[TD="bgcolor: #FFFFFF"]=IF(D2="",TEXT(C2+LEFT(B2,FIND(" ",B2)),"mm/dd/yyyy"),D2+LEFT(B2,FIND(" ",B2)))[/TD]
[/TR]
[TR]
[TH="bgcolor: #FFFFFF"]E3[/TH]
[TD="bgcolor: #FFFFFF"]=IF(D3="",TEXT(C3+LEFT(B3,FIND(" ",B3)),"mm/dd/yyyy"),D3+LEFT(B3,FIND(" ",B3)))[/TD]
[/TR]
</tbody>[/TABLE]

 

[debenay]

Thank you SO much!

 

[lrobbo314]

───────────────────░█▓▓▓█░▇▆▅▄▃▂
──────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
─────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
──────────░░░───░█▓▓▓▓▓▓█░▇▆▅▄▃▂ ...
─────────░███░──░█▓▓▓▓▓█░▇▆▅▄▃▂
───────░██░░░██░█▓▓▓▓▓█░▇▆▅▄▃▂
──────░█░░█░░░░██▓▓▓▓▓█░▇▆▅▄▃▂
────░██░░█░░░░░░█▓▓▓▓█░▇▆▅▄▃▂
───░█░░░█░░░░░░░██▓▓▓█░▇▆▅▄▃▂
──░█░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░█░░░█░░░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░█░░░░██░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░░█░░░░░██░░░█▓▓▓█░▇▆▅▄▃▂
─░█░█░░░█░░░░░░███▓▓▓▓█░▇▆▅▄▃▂
░█░░░█░░░██░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░█░░░░█████▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░░█░░░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░█░░░░██░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
─░█░█░░░░░████▓▓▓▓██░▇▆▅▄▃▂
─░█░░█░░░░░░░█▓▓██▓█░▇▆▅▄▃▂
──░█░░██░░░██▓▓█▓▓▓█░▇▆▅▄▃▂
───░██░░███▓▓██▓█▓▓█░▇▆▅▄▃▂
────░██▓▓▓███▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓▓▓▓▓▓█░▇▆▅▄▃▂