Formula for Duration Between 2 Date Columns

Nathan B

I need a formula for a duration of days between 2 date columns. I have no idea how to do this, as I am a new smartsheet user and not familiar with coding or formulas. Any help would be GREATLY greatly appriciated!!!

Please view attached.

Thanks!

Nic Larsen

Try by right clicking on one of your columns, choose Edit Project Settings.

Check the box for Dependencies Enabled.

This will likely find your dependency column.

Then use Start / End date to define the 2 columns you are using

Nathan B

https://community.smartsheet.com/discussion/comment/453806#Comment_453806

THANK YOU SO MUCH!!!

Paul Newcome

Depending on your needs, you could also just use a formula of

=[End Date]@row - [Start Date]@row