Schedule Variance

Sajish G Das India

I have tried to calculate the schedule variance % with the planned start date, Planned end date,Actual start date and Actual end date in Excel. I have tried below method

=NETWORKDAYS(Planned End Date, Planned Start Date)

=IF(Actual End Date="",0,IF(Actual End Date = Planned End Date,0,IF(Actual End DatePlanned End Date,NETWORKDAYS(Actual End Date,Planned End Date)-1,NETWORKDAYS (Actual End Dat,Planned End Date))))

IF(NOT(Actual Schedule=0),(Actual Schedule/Delay%),0)

Posted: Dec 21, 2017 4:51 AM (Updated by author: Dec 21, 2017 4:52 AM)

Sort By:

Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada

Sajish,

How do you plan to account for none working days? Or it is a choice to not consider them?

Posted: Dec 21, 2017 7:50 AM

Abolfazl Yousefi Darestani Manager, Quality and Continuous Improvement| Hörmann-TNR Industrial Doors Newmarket, Ontario, Canada

So, what is your question? It seems you need to consider the weekends and holidays as well.

Posted: Dec 21, 2017 8:24 AM

Stéphane Parent Self Employed / Semi-retired| Leader Maker Prince Edward Island, Canada

Please note that NETWORKDAYS should have the start date as the first argument, and the end date, as the second argument. Not the other way around.

You can optionally add a third argument identifying a range of dates to be excluded from the count (i.e. holidays).

Posted: Dec 21, 2017 9:02 AM

Please login or join to reply

Schedule Variance

Sponsors

Vendor Events

Guessing is not a strategy: How to build decision velocity with AI and real-time data

Newsletters