Networkdays and Datedif function

[favourss]

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.

[#2]

@favourss 

What does D4 contain?

What does F4 contain?

[#3]

@favourss 

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.

[#4]

D4: Start Date
E4: End Date
F4: Duration formula =NETWORKDAYS.INTL(D4,E4)
H4: Percentage cell formula: =DATEDIF(D4, TODAY(), "D")/F4

[#5]

@favourss 

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.