https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/96501.aspxTue, 18 Mar 2014 04:10:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96501donstephen0https://www.infopathdev.com:443/forums/thread/96501.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=96501<p>Hi Veera8,</p><p>Please check this <a href="http://www.infopathdev.com/forums/p/13202/47140.aspx">thread</a> for tips on how to exclude certain dates such as holidays when calculating dates. Another alternative you may attempt to use is <a href="http://www.qdabra.com/en/products/qRules_new.aspx">qRules&#39;</a> DateDiff command which allows you to include a repeating field or field in a repeating group with holidays that should be excluded in the date math. I hope I&#39;m able to point you toward the right direction.</p>https://www.infopathdev.com:443/forums/thread/96468.aspxSat, 15 Mar 2014 20:06:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96468veera80https://www.infopathdev.com:443/forums/thread/96468.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=96468Hi, I was able to calculate difference between 2 dates(startdate,enddate) and displaying in textbox(Days) following this link. http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm But, now i need to calculate the difference based on a drop down(Status). If the dropdown choice is Yes, date difference will be calculated, else display &quot;Completed&quot; in the &quot;Days&quot; textbox. How do i do this.. Kindly help..