% Schedule Complete Calculation

Rachel Kelly

I am using a formula to calculate the % schedule complete based on project start and end date.

=(NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10))

Is there a way to get this formula to just return 100% if the % complete is above 100%?

Carson Penticuff

Try this:

=IF((NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)) > 1, 1, (NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)))

jmyzk_cloudsmart_jp

Hi @Rachel Kelly

I would use the IF syntax.

"=IF( Your Formula >= 1, 1, Your Formula)"

=IF((NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10))>=1,1,(NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)))