Countdown from Due date color coded

Question 1

Explanation of Formulas:
Days Remaining for Orientation=

Put Formula in column for days remaining
=IF(H3=””, “”, IF(H3 >= TODAY(), H3 - TODAY(), “Overdue”))

–> calculates todays date to column with due date

Answer 1

Due date column =G3+90

takes the date input in column or original date initiated and calculates 90 days or how many days in advanced from due date

Question 2

=IF(COLUMN DUE DATE =””, “”, IF(COLUMN DUE DATE>= TODAY(), 90 - (TODAY() - INITIAL TASKER DATE), “Overdue”))

REF Excel spreadsheet screenshot

FORMULA to automatically update days remaining
=IF(J2=””, “”, IF(J2 >= TODAY(), J2 - TODAY(), “Overdue”))

Answer 2

yellow for due date approaching w/in 30 days (adjustable)
=AND(ISNUMBER(I2), I2 <= 30, I2 > 0)

red highlight of cell for overdue/past the due data=
=I2 = “Overdue”

days remaining = countdown

Question 3

yellow highlight for due date approaching w/in 30 days (adjustable) –> column= DUE DATE

=AND(H2<>””, H2 - TODAY() <= 30, H2 >= TODAY())

RED Highlight for column DUE DATE=
=AND(H3<>””, H3 < TODAY())