Forum Discussion

favourss's avatar
favourss
Copper Contributor
Aug 05, 2022

Networkdays and Datedif function

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.

Formulas and Functions

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 06, 2022

    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.

    • favourss's avatar
      favourss
      Copper Contributor
      Aug 08, 2022
      D4: Start Date
      E4: End Date
      F4: Duration formula =NETWORKDAYS.INTL(D4,E4)
      H4: Percentage cell formula: =DATEDIF(D4, TODAY(), "D")/F4
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Aug 08, 2022

        favourss 

        Thanks. As SergeiBaklan 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.

Resources