Forum Discussion
Next Inspection Date linked to Scoring
Hi, I'm looking for a formula that will create the next inspection date, based upon the score obtained at the latest inspection (see attached file).
I am also looking for rules that colour the next inspection date as follows:
Green - Greater than 15 days before Next Inspection Date
Amber - Next Inspection Date + 15 days
Red - Less than Next Inspection Date
Many thanks, Chris B
Hi Logaraj,
Many thanks for your help.
I think the formula needs tweaking, to show the correct date of the next inspection,
i.e. For a yearly inspection, it would add 12 months to the original date of inspection. So if the date of inspection was 10/09/17, the next inspection date would be 10/09/18.
Many thanks, Chris B
