Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

One step of my workflow needs to calculate how many BUSINESS days i have between two dates. The problem is that my customer registers the holidays in a sharepoint list. So i will need to query this list from the workflow. How can i achieve it?

share|improve this question

1 Answer 1

You could use a SharePoint Calculated Column to do the work for you and then use that in the workflow.

This blog post has some info about working with weekdays in a calculated column: http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

The answer on this thread also has a formula that may work for you: http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/d6a6b014-c09c-4436-9f18-0f151bae85b5

share|improve this answer
I will edit my answer. Sorry, i forget to comment that my customer register the holidays in a Sharepoint list. I need to query this list from the workflow. –  Ewerton Apr 10 '13 at 12:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.