Forum Discussion

Nita87's avatar
Nita87
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
PReagan's avatar
PReagan
Bronze Contributor
Jul 30, 2020

Hello Nita87,

 

Number of days between start and end date:

=NETWORKDAYS.INTL(start_date,end_date,[weekend],[holdiays])

Percentage completion of project:

=IF(NETWORKDAYS.INTL(start_date,TODAY(),[weekend],[holdiays])/NETWORKDAYS.INTL(start_date,end_date,[weekend],[holdiays])>1,
1,
NETWORKDAYS.INTL(start_date,TODAY(),[weekend],[holdiays])/NETWORKDAYS.INTL(start_date,end_date,[weekend],[holdiays]))
Nita87's avatar
Nita87
Copper Contributor
Jul 30, 2020
Thank you PReagan. I will try it right now 🙂
Many thanks
  • Riny_van_Eekelen's avatar
    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])