Jul 30 2020 08:45 AM
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 :)
Jul 30 2020 09:07 AM
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]))
Jul 30 2020 09:23 AM
Jul 31 2020 12:55 AM
@Nita87 As a variant
=MIN(1,NETWORKDAYS.INTL(start_date,TODAY(),[weekend],[holdiays])/NETWORKDAYS.INTL(start_date,end_date,[weekend],[holdiays])