The function for calculating the difference between two dates in a calculated column in SharePoint, without counting the weekends:=(DATEDIF([Start Date];[End Date];"D"))-INT(DATEDIF([Start Date];[End Date];"D")/7)*2-IF((WEEKDAY([End Date])-WEEKDAY([Start Date]))<0;2;0)+1
Leave a Reply