Forum Discussion
Chris Burgess
Jan 20, 2018Copper Contributor
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 ...
Logaraj Sekar
Jan 22, 2018Steel Contributor
- Chris BurgessJan 22, 2018Copper Contributor
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