<div>
Check this : <a href="http://www.kenhamady.com/form01.shtml" rel="ugc">http://www.kenhamady.com/form01.shtml</a>
</div>


Check this : http://www.kenhamady.com/form01.shtml [http://www.kenhamady.com/form01.shtml]

<div>
I had looked at that, but it lost me. &nbsp;I am not super good at this stuff, and some of the items in his formula threw me.<br />
<br />
Bill
</div>


I had looked at that, but it lost me.  I am not super good at this stuff, and some of the items in his formula threw me.

Bill

<div>
Thank you very much, I'll work with that. &nbsp;Thanks for spoon feeding me, I need it!<br />
<br />
Bill
</div>


Thank you very much, I'll work with that.  Thanks for spoon feeding me, I need it!

Bill

<div>
Since the formula was provided through the link in vasto's comment, he really should get a split of the points. &nbsp;I'll reopen the question if you want.<br />
<br />
mlmcc
</div>


Since the formula was provided through the link in vasto's comment, he really should get a split of the points.  I'll reopen the question if you want.

mlmcc

<div>
Thanks mlmcc. This is very widely used formula and the credit should go to Ken anyway. &nbsp;I don't think it is necessary to reopen the question.
</div>


Thanks mlmcc. This is very widely used formula and the credit should go to Ken anyway.  I don't think it is necessary to reopen the question.

<div>
<div class="content wysiwyg-content">
I am measuring how long it takes us to process and ship an order, I am using the following formula, which works great.<br />
<br />
datediff(&quot;d&quot;,(datevalue({e<wbr />bay_data.P<wbr />aid on Date})),(datevalue({ebay_d<wbr />ata.Shippe<wbr />d on Date})))<br />
<br />
Except I need it to ignore Saturday and Sunday when figuring the date difference.<br />
<br />
Help would be appreciated, thanks!<br />
<br />
Bill
</div>
</div>


I am measuring how long it takes us to process and ship an order, I am using the following formula, which works great.

datediff("d",(datevalue({ebay_data.Paid on Date})),(datevalue({ebay_data.Shipped on Date})))

Except I need it to ignore Saturday and Sunday when figuring the date difference.

Help would be appreciated, thanks!

Bill

Crystal Date Difference

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.