How about:

=IF(AND($A2>$E$1,$A2<$D$1),0,MOD($A2-$D$1+1,1))
WBD