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...
I'm not sure, hopefully someone else may be able to shed a little light on this one for you.
I hope so too.
So far nobody else have replied.
But the thing I don't understand is that the formula seem to work for a lot of users (according to their comments in the forum). So I'm not really sure why it doesn't work for me.
It would help a lot to get it to work in the Sharepoint view and not have to export to Excel or PowerBI to get the answer 🙂
- Hello, did you tried to make another test list, and used the english language instead?
