Distribute the work on daily basis

Hi,
Attached a work tracker here for your ref.

I this, We are distributing work on 6 hrs/day basis.
What I need is, I need to automate the work distribution on daily basis and should show the hrs also. and the projected date of completion. (yellow highlighted cells are where the formulas are needed)

How can we do that?

Please help. Thanks in advance
Excel Help-Updated.xlsx