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>