Project Progress % between tow dates

Copper Contributor

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 :)

3 Replies

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]))
Thank you @PReagan. I will try it right now :)
Many thanks

@Nita87 As a variant

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