is there a task duration formula

[jramsey18]

This spreadsheet is a schedule of due dates for a meeting the company is going to on Tuesday. I need a task duration formula, I think. Or maybe something else. I'm not well versed in any formulas or functions in excel.
To stress to the client that schedule is very important- We know that we will meet all due dates, but the client must meet all dates for approval & comments due or else two things can happen: The final due date can stay the same and task duration will be shorter for each task, or the task duration can stay the same and the due dates, including the final, will be pushed back.
What we want the spreadsheet to show is the former: the final due date can stay the same and task duration will be shorter for each task.
This is what we have to start, in which C is the due date, F is approval & comments due, and B is task duration:

C6 = C4+42
C7 = C6+16
F7 = WORKDAY(C7, D7)
C9 = F7+B9
B9 = 21

C4 is the kickoff meeting and is what everything depends on in the beginning and C16 is the final due date that needs to stay the same.

If they miss the deadline in F7 by 5 days, we would change the date of F7 and C9 would change accordingly, but what we want is B9 to change instead so C9 would change without us having to do it because C9 = F7+B9

So I guess there needs to be a formula in all of the Bs but I don't know what kind of formula would do what we need it to.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[mjeanold]

If you want B to display the number of days between the due date (in column C) and the date of approval and comments (in column F), try a version of this

Please Login or Register  to view this content.

The DATEVALUE function converts dates into serial numbers for use in calculations, but will only work properly if both dates are entered in the same format (ie, both xx-xx-xx or xx/xx/xx, not a mix).

[jramsey18]

I have attached it.

[jramsey18]

If you want B to display the number of days between the due date (in column C) and the date of approval and comments (in column F), try a version of this

Please Login or Register  to view this content.

The DATEVALUE function converts dates into serial numbers for use in calculations, but will only work properly if both dates are entered in the same format (ie, both xx-xx-xx or xx/xx/xx, not a mix).

This just gives a 0 in the cell with a blue line running through it and the adjacent cell.

[FDibbins]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)