How to find number of WorkDays between 2 dates using InfoPath-2010?

Question

How can I find the number of WorkingDays by selecting StartDate & EndDate in InfoPath-2010 ? (Excluding Saturday & Sunday. Means only WeekDays).

Please specify the Rule or the mehtod.

Answer 1

If proposted codeless approaches don't appropriate in your case, another approach could be to create custom webservice to do this and call it from InfoPath. I used this method in my case.

Answer 2

There is very detailed description of codeless (aka nocode) approach, just with rules:

• Alec Pojidaev's InfoPath Blog
  Stuff published for no reason (cool codeless infopath solutions mostly)
  Infopath codeless programming (walkthrough) 2

the 2nd sentence of which is:

Updated: 5 more forms added at the bottom: “work days calculation (excluding weekends and holidays)”

There are more trivial/obvious approaches with the use (of coding) code-behind you could have found easily by searching

Answer 3

Assuming you have access to Excel Services, these links may be useful to you:

http://www.youtube.com/watch?v=MHXX9ZV-74w

http://www.bizsupportonline.net/blog/2011/02/calculate-work-days-exclude-holidays-infopath-2010-sharepoint-2010-excel-services/