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

Hi there,

not sure if this is what You want (because I did not see yellow highlighted cells in Your attachement), but check my attachement:
Excel Help.xlsx

Hope it helps

Hi,
Sorry, I found that 5 min later and uploaded the new sheet.

The solution you provided was really good.. I just need one more thing.

In column 'E' the completion date should also come automatically. Can you please help me to get that also?

Hi there,
You want it You got it...

Note, that there are 2 modifications in comparison to Your original worksheet:
1) Added 1 column at beggining of Your date set (column H): there needs to be one column with date on which none of the projects will start
2) cell H1: if You want to adjust the daily time load. Currently set up for 6hrs/day, but You can adjust as needed.
Excel Help.xlsx

(Also note that formula used for Completition day date is an array formula, and needs to be confirmed with Ctrl+Shift+Enter instead of simple Enter)

So check it!

Thanks for helping and explaining the details..

This solved my problem now

Thanks a ton

You are welcome!
(and thanks for rep.)