Multiple Duration columns (or a way to calculate number of day between two date columns)

GeorgeWaite

I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: 

• Target Date

• • Act Start
• • Act Finish
• • Approval Date

 

I have my the project settings turned on so that "Act Start" and "Act Finish" create teh Gnatt timeline with dependencies. So i can calculate the Actual work (duration time) with no problem.

 

The "Target Date" column is used to show the origional milestones, and I can compare it to the Act Finish to add in conditional formating, so no problem here.

 

What I can't seem to do is count the turnaround (or approval) timing, but subtracting the "Act Finish" date from the "Approval Date". I deally this woudl give me a count of working days, just like the duration column. But I can't find a formula that will do this, or a way to add a second "duration column"

 

Is there any way to do this? 

Thanks 

 

Kennedy Stomps

Hi George-- I'm so sorry you didn't get a timely reply on this! Have you checked out this article I wrote on Baselining from our Help Blog? I think this might give some direction on how to accomplish this in your sheet!