IF OR Fuction

Based on what you had here it is 

=IF(B3=$D$2,1,IF(A3<$D$2,($D$2-A3+1)/(B3-A3+1)))

Zoltan furmula is correct with minor correction in case A > D or B < D or A=D.

=IF(B3<=$D$2,1,IF(A3<=$D$2,($D$2-A3+1)/(B3-A3+1),0))

And what about non-work days such as vacations?

And what about multiple resouces with different calendars?

And what about shiftwork on same activity?

Unless activities are duration type such as concrete curing status and updating is a matter of volume of work. Statusing and updating activities that perform volume of work without considering volume of work is not a good idea.

Thanks Zoltan and Rodel,

That did help.

Rafel,

The weightage per activity is already given based on the resource requirement and its 7X7 job. So the duration consumed X by the weightage/ activity gives me the planned %.

Thanks

Jithin

glad I could help wants exactly sure what you were trying to do.

glad I could help but my formula was correct based on what you had

you had  A<D

NOT A>D or B<D

was not excalty sure I but I did think your paramaters were incorrect to begin with but that was not what you asked

• That activity time has elapsed or that some effort has been performed does not mean some volume of work has been done.
• Using elapsed time to calculate progress of work is usually wrong even in the most simple of job as things rarely happen exactly as planned.