I am trying to make a worksheet that will track the annual inspection dates
for my equipment and basically change color when the inspections are comming
due or are overdue. Im using conditional foramtting what would the formula be
if i did an inspection on 6-sep-05 and i want excel to tell me when it is 5
days before the due date which would be 6-sep-06.