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

Hannah Johnson

Hi!

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?

THANKS!

-Hannah

Paul Newcome

To use the [Actual Start] if it is a date and TODAY() if it is not, you would use a basic IF statement.

=IF(ISDATE([Actual Start]@row), [Actual Start]@row, TODAY())

Then you would just subtract the [Estimated Start] from that.

=IF(ISDATE([Actual Start]@row), [Actual Start]@row, TODAY()) - [Estimated Start]@row