Quote Originally Posted by dilipandey View Post
Hi rapscalli,

Welcome to the forum.

Use the below formula in cell D2 and drag it to right and down....

=IF(AND(D$1>=$B2,D$1<=$C2),$A2/(($C2-$B2)+1),2)

Regards,
DILIPandey

<click on below 'star' if this helps>
hi DILIPandey,

many thanks, i've got it working with your help. I also had to add in
WEEKDAY(F$1,2)<6
to avoid weekends
and
(ISERROR(VLOOKUP(F$1,'logic-Holidays'!$A:$A,1,0))
to avoid holidays.

It is all working correctly now. If only i could get the data in the correct format from ms project!