Calculating Time Between Dates, Excluding Sundays

[harrietohs]

Crystal 8.5 or 11 ( I have both installed on my system)

I want to know if a formula can be written to detect when the number of days between a field contaning an Intake Date and a field containing an Outcome Date is less than 4 days, but not include Sundays in that count.

For example:

If an animal arrives on a Monday, it becomes legally ours on Friday.

If an animal arrives on a Saturday, it becomes legally ours on Thursday, because Sunday does not count as a legal business day.

Thanks,

Harriet Farmer
Ottawa Humane Society

 

[lbass]

Please see Ken Hamady's solution:

http://www.kenhamady.com/form01.shtml

Just adapt it to allow Saturdays.

-LB