Forum Discussion
favourss
Aug 05, 2022Copper Contributor
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...
HansVogelaar
Aug 05, 2022MVP
favourss
Aug 08, 2022Copper Contributor
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