Hi all,
I need to create a spreadsheet, which has an integrated 15 working day SLA. The SLA clock starts 1 day after the 'Claim Lodged Date' (Column A). The SLA clock then stops when a barrier is raised (on the day of the 'Barrier Raised Date') and then restarts when a barrier is closed (on the day of the 'Barrier Closed Date').
If a claim has 2 barriers, the SLA should only restart, once both barriers are cleared and there is a 'Barrier Closed Date' captured in Columns D & G.
I need Column H (SLA Days Remaining), to be able to automatically calculate how many working days we have left, before we hit the SLA, based on the 'Barrier Closed Date'. I also need Column H to be green when we're within the 15 working day SLA, but turn red on the 15th working day of the SLA (which is the last day before we miss the deadline). The case would then need to remain as red thereafter.
Please see example attached.
Any help would be greatly appreciate!
I need to create a spreadsheet, which has an integrated 15 working day SLA. The SLA clock starts 1 day after the 'Claim Lodged Date' (Column A). The SLA clock then stops when a barrier is raised (on the day of the 'Barrier Raised Date') and then restarts when a barrier is closed (on the day of the 'Barrier Closed Date').
If a claim has 2 barriers, the SLA should only restart, once both barriers are cleared and there is a 'Barrier Closed Date' captured in Columns D & G.
I need Column H (SLA Days Remaining), to be able to automatically calculate how many working days we have left, before we hit the SLA, based on the 'Barrier Closed Date'. I also need Column H to be green when we're within the 15 working day SLA, but turn red on the 15th working day of the SLA (which is the last day before we miss the deadline). The case would then need to remain as red thereafter.
Please see example attached.
Any help would be greatly appreciate!