Creating a Working Progress Sheet with Workday Functions

Hi All,

I'm trying to create a working progress sheet where I have an 'Order Date' & 'End Date' and a number of hours per job for different elements (design / manufacture / test) from the information of 'Order Date' & 'End Date' and a number of hours it works out critical dates. I'm not very good with excel hence why i'm asking for help.

i have attached a picture of my spreadsheet so far.

if anyone can help it would be great.

Example.jpg

Miroslav,

Please see the attached workbook. i have filled out the dates for an example but its the dates what i need to be automatic from the hours which i would input into the pink highlighted areas.

WIP SHEET.xlsx

Basically yes but i want to put Workday Dates in the cells and not hours, but it also has to take into account the start and dispatch date.

The elements will be:

Engineering - Cells O to P
Manufacturing - Cells U,W - Y
Test - Cells Z - AA

Hope this helps