Sparky83
Prominent Member
Hi all,
I wonder if anyone can help me, I'm struggling finding the answer on google for a spreadsheet i need to complete for work.
Basically I'm trying (and failing) to create a tracker for jobs that are time critical. What i have is a list of jobs in the first column. Then the date they are due on the next column, then if they are compliant or not in the last column. What i would like to do in the "Compliance column" is show how many days until they become non compliant. i.e. "32 Days left"
Job List Due Date Compliant?
Job 1 15/05/2016 1 day
Job 2 22/05/2016 8 days
Job 3 29/05/2016 15 days
Job 4 05/06/2016 22 days
Job 5 12/06/2016 29 days
Job 6 19/06/2016 36 days
Job 7 26/06/2016 44 days
Job 8 03/07/2016 51 days
Job 9 10/07/2016 Compliant (Shows as Compliant as its over 56 days (8 weeks) from due date)
Any help here would be great as I'm pulling my hair out trying all sorts of IF/IFS formulas and conditional formatting etc etc but just cant work it out.
I wonder if anyone can help me, I'm struggling finding the answer on google for a spreadsheet i need to complete for work.
Basically I'm trying (and failing) to create a tracker for jobs that are time critical. What i have is a list of jobs in the first column. Then the date they are due on the next column, then if they are compliant or not in the last column. What i would like to do in the "Compliance column" is show how many days until they become non compliant. i.e. "32 Days left"
Job List Due Date Compliant?
Job 1 15/05/2016 1 day
Job 2 22/05/2016 8 days
Job 3 29/05/2016 15 days
Job 4 05/06/2016 22 days
Job 5 12/06/2016 29 days
Job 6 19/06/2016 36 days
Job 7 26/06/2016 44 days
Job 8 03/07/2016 51 days
Job 9 10/07/2016 Compliant (Shows as Compliant as its over 56 days (8 weeks) from due date)
Any help here would be great as I'm pulling my hair out trying all sorts of IF/IFS formulas and conditional formatting etc etc but just cant work it out.