Doula.K
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment