Forum Discussion

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

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

CoutinhoUK

Copper Contributor

Aug 26, 2020

PradeepKhanna

Your formula has worked perfectly for my case, however i was wondering is there is any way to add onto this formula a list of bank holidays days like in Excel with Networking days.