Hi Paul
Many thanks for the prompt response. However this does not appear to gie me what I need. What I am trying to do is provide an indication as to whether a Task/Milestone is at risk if dependant tasks are running late without having to give management the full project plan.
I attach my sample spreadsheet and in H14 I have put your formula and got the result#N/A.
Basically in any given row I may have dependencies from column I through to Z. I want to check if any of those dependent tasks are running late and therefore makes the Milestone at risk before it actually happens.
Hope this makes it more clear.
any help would be appreciated.
Tony

Attached Files

At Risk Milestone Report.xlsx (12.8 KB, 28 views)