Help Please......
I have 10 assets that I plan maintenance for. Each planned maintenance exam has a +/- 2 day tolerance. Each asset runs in order from 1 to 10 then over again (every 10 days).
I need a column that will calculate how many days above or below its actual completion date was compared to its planned completion date.
I assume it will be a combination of IF, SUM and MOD, but have spent a while trying to figure something out without much success yet.
Attached is an example spreadsheet with a column providing the expected result.
Bookmarks