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...
Thanks for the post, the formula is working perfectly fine with my sharepoint list.
=(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
My additional requirement is that Friday and Saturday is off days for me.