Calculating Duration Between Two Dates
I'm trying to calculate durations between two dates. Would like to calculate days between:
 Date Submitted and Date Assigned to be calculated in a (Days to Assignment column)
 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.
Best Answer

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.
Answers

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
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.

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.

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).
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!