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
Check out the Formula Handbook template!