I've made some changes to the spreadsheet so am posting a slightly different version of this problem - I'm probably just going round in circles! When the completion date is greater than the target date the result in the Situation column should read "Late", unfortunately it doesn't - I can't seem to see the error.
I attached the revised spreadsheet with example.
Many thanks
Bookmarks