Sum only work days

%3CLINGO-SUB%20id%3D%22lingo-sub-1335954%22%20slang%3D%22en-US%22%3ESum%20only%20work%20days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335954%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20SharePoint%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20columns%20in%20my%20list%20which%20is%20Startdate%20and%20Enddate.%20I%20have%20a%20third%20column%20(Total%20Days)%20which%20is%20the%20difference%20between%20the%20Enddate%20and%20Startdate.%20But%20I%20need%20to%20exclude%20the%20weekends%20to%20make%20it%20calculate%20only%20the%20weekdays.%20I%20have%20tried%20to%20copy%20the%20Networkdays%20formula%20of%20Excel%2C%20but%20it%20didn't%20work.%20Further%2C%20if%20the%20Startdate%20is%20Monday%20and%20the%20Enddate%20is%20Friday%2C%20the%20result%20will%20be%204%20but%20it%20need%20to%20be%205%20because%20i%20need%20to%20include%20Monday%20also%20as%20part%20of%20the%20(Total%20Days).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Help%20Bonus(%20when%20I%20display%20the%20calendar%20of%20the%20Total%20Days%20column%2C%20it%20will%20show%20the%20%22red%20bar%22%20from%20Monday%20to%20Thursday.%20But%20Friday%20will%20also%20need%20to%20be%20highlighted%20with%20the%20%22red%20bar%22).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20this%20problem%3F%3C%2FP%3E%3CP%3EThe%20Calendar%20part%20will%20also%20be%20very%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi SharePoint community,

 

I have 3 columns in my list which is Startdate and Enddate. I have a third column (Total Days) which is the difference between the Enddate and Startdate. But I need to exclude the weekends to make it calculate only the weekdays. I have tried to copy the Networkdays formula of Excel, but it didn't work. Further, if the Startdate is Monday and the Enddate is Friday, the result will be 4 but it need to be 5 because i need to include Monday also as part of the (Total Days).

 

- Help Bonus( when I display the calendar of the Total Days column, it will show the "red bar" from Monday to Thursday. But Friday will also need to be highlighted with the "red bar"). 

 

Can someone help me with this problem?

The Calendar part will also be very helpful.

0 Replies