Reporting the number of weeks overdue

Hi,

I’ve been on the forum a lot recently trying to create a project model and there is a new element I need.

I would like a formula to calculate if a task has become overdue taking into account 4 factors:
The current week
The Start Week of the task
The Duration number of weeks of the task
The % completion of the task

If a project is 100% complete then I need it to be ignored. If it’s not 100% but should have already been completed I would need the number of weeks overdue reported (in the red cells) – this I do not know how to do, any ideas?

Once the above part is working I need it to be pulled through to the data tab with the task, completion % and weeks overdue listed (sorted by the number of weeks overdue listed first).

I have attached an example which includes sample data along with justifications

Paul

Hi,

Check the updated file

Punnam

Its certainly getting there lol

Thanks all!!

pauldaddyadams

All the solutions worked fine ? I just want to whether mine worked or not in real data ?

Punnam

Hi Punnam

Only Ace's worked on this occasion. Yours needed to take into account the start week and the other needed to take into consideration the current week number (based on a cell - I think it was using a formula to drive the current week number)

pauldaddyadams

Thanks for the feedback

Punnam