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
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!