Forum Discussion
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...
D4: Start Date
E4: End Date
F4: Duration formula =NETWORKDAYS.INTL(D4,E4)
H4: Percentage cell formula: =DATEDIF(D4, TODAY(), "D")/F4
E4: End Date
F4: Duration formula =NETWORKDAYS.INTL(D4,E4)
H4: Percentage cell formula: =DATEDIF(D4, TODAY(), "D")/F4
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.