Formula for Duration Between 2 Date Columns

Nathan B · 09/12/24

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 · 09/12/24

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 · 09/13/24

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

THANK YOU SO MUCH!!!

Paul Newcome · 09/13/24

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

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

Formula for Duration Between 2 Date Columns

Answers

Help Article Resources

Categories