For “Number of days since certification” in cell B:1, the result should be number of days since date certified (cell B:4) minus the current DATE. As each passing day, the number should increase by 1.This result should be in cell B:1.
For B5, it should be amber color, when 60 days before due date (B2). B5 should turn red when due date has expired. For B5, any other days it should be green.
Can someone give me the proper programming for the CELLS mentioned. View the attachment.