Forum Discussion

Copper Contributor

Jul 30, 2020

Project Progress % between tow dates

Hi everyone I'm trying to calculate de % progress of my projects and I use NETWORKDAYS.INTL to estimate my project duration in days. How can i calculate the nr of Days Completed (workdays) and the ...

excel

Formulas and Functions

Nita87

Copper Contributor

Jul 30, 2020

Thank you PReagan. I will try it right now 🙂
Many thanks

Riny_van_Eekelen

Platinum Contributor

Jul 31, 2020

Nita87 As a variant

=MIN(1,NETWORKDAYS.INTL(start_date,TODAY(),[weekend],[holdiays])/NETWORKDAYS.INTL(start_date,end_date,[weekend],[holdiays])