Start end date formula

Good Day, I have a list of projects that have start and end dates. Each day in between needs a specific value. What formula will insert that value on all dates in-between a given starting and end dates? Please see attachment. Cells in red need the formula. This is a small example, but my actual data has a lot more "projects". Thank in Advance!

Try this in B2:

=IFERROR(1/(1/SUMIFS($J:$J,$G:$G,B$1,$H:$H,"<="&$A2,$I:$I,">="&$A2)),"")

Drag the formula to the right and down.

An other option:

Please try in B2 and copy across and down:

Formula:

Please Login or Register  to view this content.

Thank you!

You are welcome