Formula to display duration of a project

Adolfo E.

Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?

Nic Larsen

If you enable Dependencies under the project settings it will auto add a duration column. Assuming you indent all your tasks to your first row, it'll capture your total project duration. 

Mike Wilday

In addition to that, you can also use the networkdays, or netdays formula to calculate the number of working days or calendar days between the first and last date in the project... 

• https://help.smartsheet.com/function/netdays
• https://help.smartsheet.com/function/networkday (Adds 1 day for some reason)
• https://help.smartsheet.com/function/networkdays