Monday, November 25, 2013

SharePoint Formula for calculated column : No of Days excluding Saturdays and sundays SharePoint

=(DATEDIF(StartDate,EndDate,"d"))-INT(DATEDIF(StartDate,EndDate,"d")/7)*2-IF((WEEKDAY(EndDate)-WEEKDAY(StartDate))>0,2,0)+1

No comments:

Post a Comment