Forum Discussion
Calculate working days in Sharepoint
- Hi
Can you please help me to calculate working days between two dates in Sharepoint. My weekends are Saturdays and Sundays. I tried using your first formula. But I failed. It showed an error. Would you please guide me. Thank you for your answer but I have tried that one without any luck. I tried it again just now and still I get an error message.
I have changed "start date" and "end date" to the names of my columns and I have checked the code but still error.
I don't know why. Even if I don't think so but can it be because I have swedish as language in Sharepoint?
So you added a calculated column formatted as text and used the formula ensuring the column names match your column names? (Case and space sensitive) I tested it on a classic calendar and it worked when I looked at the all events list view.
Also please give us some more details to the type of list you are using along with some screen shots or more information about the "error" you are getting.
Yes. I have tried and double tried but still get the error. When I scan through different forums I can see that people get some formulas to work but when I try the same formulas it doesn't work for me. I have attached 3 screenshots.
I hope that you'll see something in them that I'm doing wrong....
