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

AngelEG

Copper Contributor

Feb 01, 2021

Works like a charm, thank you!