Project Progress % between tow dates

%3CLINGO-SUB%20id%3D%22lingo-sub-1556424%22%20slang%3D%22en-US%22%3EProject%20Progress%20%25%20between%20tow%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3CBR%20%2F%3EI'm%20trying%20to%20calculate%20de%20%25%20progress%20of%20my%20projects%20and%20I%20use%20NETWORKDAYS.INTL%20to%20estimate%20my%20project%20duration%20in%20days.%3CBR%20%2F%3EHow%20can%20i%20calculate%20the%20nr%20of%20Days%20Completed%20(workdays)%20and%20the%20%25%20progress%20just%20to%20the%20end%20of%20the%20project%2C%20to%20avoid%20%25%20over%20100%25%20(in%20case%20of%20past%20projects)%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20you%20help%20me%20on%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1556424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556499%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20Progress%20%25%20between%20tow%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556499%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744959%22%20target%3D%22_blank%22%3E%40Nita87%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENumber%20of%20days%20between%20start%20and%20end%20date%3A%3C%2FP%3E%3CPRE%3E%3DNETWORKDAYS.INTL(start_date%2Cend_date%2C%5Bweekend%5D%2C%5Bholdiays%5D)%3C%2FPRE%3E%3CP%3EPercentage%20completion%20of%20project%3A%3C%2FP%3E%3CPRE%3E%3DIF(NETWORKDAYS.INTL(start_date%2CTODAY()%2C%5Bweekend%5D%2C%5Bholdiays%5D)%2FNETWORKDAYS.INTL(start_date%2Cend_date%2C%5Bweekend%5D%2C%5Bholdiays%5D)%26gt%3B1%2C%3CBR%20%2F%3E1%2C%3CBR%20%2F%3ENETWORKDAYS.INTL(start_date%2CTODAY()%2C%5Bweekend%5D%2C%5Bholdiays%5D)%2FNETWORKDAYS.INTL(start_date%2Cend_date%2C%5Bweekend%5D%2C%5Bholdiays%5D))%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556564%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20Progress%20%25%20between%20tow%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556564%22%20slang%3D%22en-US%22%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E.%20I%20will%20try%20it%20right%20now%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EMany%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558050%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20Progress%20%25%20between%20tow%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558050%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744959%22%20target%3D%22_blank%22%3E%40Nita87%3C%2FA%3E%26nbsp%3BAs%20a%20variant%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DMIN(1%2CNETWORKDAYS.INTL(start_date%2CTODAY()%2C%5Bweekend%5D%2C%5Bholdiays%5D)%2FNETWORKDAYS.INTL(start_date%2Cend_date%2C%5Bweekend%5D%2C%5Bholdiays%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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])