Calculating Duration Between Two Dates

Aaron Villaverde

I'm trying to calculate durations between two dates. Would like to calculate days between:

1. Date Submitted and Date Assigned to be calculated in a (Days to Assignment column)
2. Date Submitted and Date Completed to be calculated in a (Days to Complete column)

I don't want or have a need for predecessors or durations and those are the only answers I'm finding. The problem is when I selected dependencies it keeps messing up my start and end dates for each column. So i get everything set up and everything calculates perfectly then I go back into project settings and notice that the start and end date columns match for both Days to Assignment and Days to Complete and the predecessor and duration column are the same.

When I try to calculate an average for each column in my reference sheet one calculates correctly the other errors out with a # divide by zero error. The formulas are correct so not sure why it errors out and the only thing I can think is because the dependencies and durations are messing up the calculation. If I choose a column not in the dependency/predecessor column it calculates with no issue.

Aaron Villaverde

So i was able to figure it out using another post on here by using the formula below.

For Net Work Days

=Networkdays([start date]1, [end date]1)

I was using duration and predecessors incorrectly and it was throwing off my sheet. The formula above helped my calculate just the difference in days I was looking for and then it properly calculated on my reference sheet. Thanks for the reply I just figured it out so I'll be closing it out.  

Stefan

Hi @Aaron Villaverde ,

could you post a little more detail about the formulas you use and the structure of your sheet and maybe an example? This will help to help you :-)

Greetings

Stefan

Aaron Villaverde

So i was able to figure it out using another post on here by using the formula below.

For Net Work Days

=Networkdays([start date]1, [end date]1)

I was using duration and predecessors incorrectly and it was throwing off my sheet. The formula above helped my calculate just the difference in days I was looking for and then it properly calculated on my reference sheet. Thanks for the reply I just figured it out so I'll be closing it out.  

Jodi

I'm attempting to do something similar, but I need the Duration calculation to look at the assigned work days, not total days. I can't seem to find a way to use a formula similar the the provided Duration calculation (which looks at Start Date and End Date, but I want to look at Baseline Start & End Dates).