https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/38047.aspxTue, 03 Feb 2009 15:32:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38047mrdesignit0https://www.infopathdev.com:443/forums/thread/38047.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=38047<p>I have looked into several VB Scripts and have yet to discover what the code should look like if I would like to exclude the weekends and Holidays.&nbsp; The ones that I have seen don&#39;t seem to work or I am missing something.&nbsp; Below is the Expression I am using on the starting date;</p><p>(number(substring(@Ending_Date, 9, 2)) + floor((153 * (number(substring(@Ending_Date, 6, 2)) + 12 * (floor((14 - number(substring(@Ending_Date, 6, 2))) / 12)) - 3) + 2) / 5) + (number(substring(@Ending_Date, 1, 4)) + 4800 - (floor((14 - number(substring(@Ending_Date, 6, 2))) / 12))) * 365 + floor((number(substring(@Ending_Date, 1, 4)) + 4800 - (floor((14 - number(substring(@Ending_Date, 6, 2))) / 12))) / 4) - floor((number(substring(@Ending_Date, 1, 4)) + 4800 - (floor((14 - number(substring(@Ending_Date, 6, 2))) / 12))) / 100) + floor((number(substring(@Ending_Date, 1, 4)) + 4800 - (floor((14 - number(substring(@Ending_Date, 6, 2))) / 12))) / 400) - 32045) - (number(substring(., 9, 2)) + floor((153 * (number(substring(., 6, 2)) + 12 * (floor((14 - number(substring(., 6, 2))) / 12)) - 3) + 2) / 5) + (number(substring(., 1, 4)) + 4800 - (floor((14 - number(substring(., 6, 2))) / 12))) * 365 + floor((number(substring(., 1, 4)) + 4800 - (floor((14 - number(substring(., 6, 2))) / 12))) / 4) - floor((number(substring(., 1, 4)) + 4800 - (floor((14 - number(substring(., 6, 2))) / 12))) / 100) + floor((number(substring(., 1, 4)) + 4800 - (floor((14 - number(substring(., 6, 2))) / 12))) / 400) - 32045) </p><p>&nbsp;The problem is this code works along with another Date Picker &quot;Ending Date&quot;&nbsp; They cross check each other and then write the difference of the two in another Text Field.&nbsp; I need the users not allow the weekends.&nbsp; Also if I decide I need Monday - Friday off, the system shows this as 4 days off, assuming I&#39;m returning on Friday.&nbsp; Is there a fix for that as well. <br /></p>