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:  =DATEDI...
Formulas and Functions
  • 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