Aug 05 2022 10:07 AM - edited Aug 05 2022 10:07 AM
Duration: NETWORKDAYS.INTL and DATEIF is returning odd number expressed in percentage.
Start Date: 8/1/2022
End Date: 8/3/2022
Duration formula: NETWORKDAYS.INTL
Progress Formula: =DATEDIF(D4, TODAY(), "D")/F4 and is returning 133%
Is there an issue here? Or is there a better alternative function for this scenario.
Aug 05 2022 11:39 AM
Aug 06 2022 07:43 AM
NETWORKDAYS.INT returns number of work days IN the period, includes start and end date. If start date is Aug 01, end date is Aug 03 - it returns 3. Aug 01, 02, 03 are calculated.
DATEDIF(start, end, "D") says how many days BETWEEN start and end. As a comment, =end-start returns the same, that's equivalent of above formula.
For above start and end it returns 2. Aug 01 + 2 = Aug 03.
Aug 08 2022 10:36 AM
Aug 08 2022 12:39 PM
Thanks. As @Sergei Baklan remarked, WORKDAYS.INTL includes the start and end date, while DATEDIF returns the number of days between the two dates. So if there are no weekend days involved, DATEDIF will return 1 day less than NETWORKDAYS.INTL for the same start and end date.