Forum Discussion
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...
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))+1I ran it across about 1000 rows in an excel, and the outcome was the same as NETWORKDAYS excel formula across all of them
this works, may i know if this can calculate the weekend from start date to end date ?
- Works like a charm, thank you!
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.
