Forum Discussion
Networkdays and IFERROR
Hi,
Here is an excel formula to calculate number of workdays between two dates:
=IFERROR( IF ( A2 = B2, 0, NETWORKDAYS( A2, B2 ) -1 ), "" )
is it possibe to write this formula in SharePoint List as a calculated column please?
Thanks
Manoj the following should work:
=(DATEDIF(Start,End,"D"))-INT(DATEDIF(Start,End,"D")/7)*2-IF(WEEKDAY(End)<WEEKDAY(Start),2,IF(OR(WEEKDAY(End)=7,WEEKDAY(Start)=1),1,0))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
2 Replies
Manoj the following should work:
=(DATEDIF(Start,End,"D"))-INT(DATEDIF(Start,End,"D")/7)*2-IF(WEEKDAY(End)<WEEKDAY(Start),2,IF(OR(WEEKDAY(End)=7,WEEKDAY(Start)=1),1,0))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
