Forum Discussion

nima_einarmattsson's avatar
nima_einarmattsson
Copper Contributor
Dec 27, 2019

Calculate working days in Sharepoint

Hello   I want to calculate work days (mon-fri) between to columns in my Sharepoint list.  Both columns have date and time.   It works for me to calculate days with this formula: "=EndDate-Start...
SharePoint Online
PradeepKhanna's avatar
PradeepKhanna
Copper Contributor
Jun 25, 2020

This one did it for me:

=(DATEDIF([Start Date],[End Date],"D"))-INT(DATEDIF([Start Date],[End Date],"D")/7)*2-IF(WEEKDAY([End Date])<WEEKDAY([Start Date]),2,IF(OR(WEEKDAY([End Date])=7,WEEKDAY([Start Date])=1),1,0))+1

I ran it across about 1000 rows in an excel, and the outcome was the same as NETWORKDAYS excel formula across all of them 

Mark1112's avatar
Mark1112
Copper Contributor
Sep 15, 2022

PradeepKhanna 

 

this works, may i know if this can calculate the weekend from start date to end date ?

 

Resources