Calculating Days Between Estimated and Actual Start Dates (including projects which haven't started)


I've got a project tracking sheet that has the following columns:

Estimated Start Date

Actual Start Date

I need to calculate how long a project has been waiting to start. Some projects don't have an actual start date, though. So the formula needs to know that blank dates in the actual start column should be counted as "TODAY."

Any ideas on how to get this calculation done?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!