Correct Countdown Timer

[aStarxx]

I have read many post about "Countdowns" and "Timers". None of which provide me with the correct formula or knowledge into what I am actually looking for. So I figured I would ask the question here specifically to see if I could grab some help and understanding.

Back ground: This is need for receiving purposes on materials used in a manufacturing setting.

Receiver: Once material is received needs to input data into a spread sheet under the headings: PO # / Received Date / Job # / Material / Size / Amount. On each row received in the cell to the right of the "Amount" I would like to add another column titled "Time Duration". This time will represent how long the material has set on the dock before being processed or moved to the correct location. Everything needs to start at "30 Days", once the timer counts down to "15 Days" I want the cell to turn yellow. Then once the timer hits the last day I want the cell to turn Red.

Every batch of material received in will be entered in on a new Row, so there would need to be a timer at the end of each Row that would be started once the data was entered.


I hope I explained this well enough, if anyone could help it would be greatly appreciated.

Thanks!!

 

[Yongle]

With received date in cell B2, this formula is Time Duration
=B2+30-TODAY()
format Time Duration as a Number with 0 decimal places

Apply 2 conditional formatting rules
1, Highlight Cells BETWEEN 2 and 16 (format with YELLOW Fill , with font Colour set to automatic)
2. Highlight Cells LESS THAN 2 (format with RED Fill , with font Colour set to automatic)