Discussion: How do I exclude weekends when counting the number of days between a start and end time?
The only purpose of this post is to relay a discussion that has been active for almost two years on LinkedIn, in the SharePoint User Managed Solutions group:
How do I exclude weekends when counting the number of days between a start and end time?
You would think that such a question would bring a straightforward answer. But apparently it’s not the case, and depending on their site settings people get different results.
Feel free to try out the suggestions in the discussion, and let the group know which one(s) worked for you!
The SharePoint User Managed Solutions group on LinkedIn currently has ~600 members. It’s purpose is to discuss customizations done from the user’s side (Calculated Columns, SharePoint Designer, Web services, client-side scripts, Office 365, etc.).
Why are such seemingly simple things so complicated?? (Answer: It’s SharePoint.
A quick and dirty method would be to calculate the number of days between to two dates – divide that number by 7 then multiply the result (whole number only) by two and take that result away from the original figure – this should give a fairly accurate result.
=(NoOfDay-((NoOfDays/7)*2))
Heather, this is definitely a nice workaround, considering how complex the other formulas are! It’s just that sometimes you need the exact value, for example when you use it for a quote or a deadline.