Creating a Days On hand formula counting down to zero

[lebronjames2019]

test.xlsx

I am trying to create a formula that counts the days on hand (with decimals if possible), until the projected inventory goes below 0, and then DOH would stay at 0 until the actual projected goes above 0, when it would then count down again how many days until it hit 0, etc.

Please see attachment, thank you!

[Estevaoba]

Not sure I understand, but maybe this in U28 and drag across:

=IF(U27="","",IF(U27<=0,0,COUNTIF(U27:NV27,">0")))

Good luck!