DateDif in SharePoint

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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.