Calculate days left in a week period as they pass.

Hi, b12=

Formula:

=sumproduct(($i$10:$i$13-$h$10:$h$13)*(row($h$10:$i$13)-row($b$9)=column(a1)))+1