Task ID Equipment Task Description Frequency (days) Last Done Next Due Status T01 Compressor Change oil 30 2026-03-01 =F2+C2 =IF(F2<TODAY(),"OVERDUE",IF(F2=TODAY(),"DUE TODAY","OK"))
=COUNTIF(Sheet1.J:J, "Pending") → pending tasks =COUNTIF(Sheet1.J:J, "Overdue") → overdue tasks =COUNTIF(Sheet1.F:F, "<"&TODAY()) → all past due dates Task ID Equipment Task Description Frequency (days) Last
Use "Conditional Formatting" -> "New Rule" -> "Use a formula." Enter =$D2 < TODAY() and set the background color to bright red. You will see violations instantly. "Pending") → pending tasks =COUNTIF(Sheet1.J:J