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 % progress just to the end of the project, to avoid % over 100% (in case of past projects)?

Could you help me on that?

 

Thank you so much 🙂

excel
Formulas and Functions

3 Replies

  • 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]))
      • 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])