The 8 business days left is a variable based on the start date and end date, so the 8 can't be hard coded into the calc.
Thanks Kim From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Lee Smith Sent: Wednesday, February 20, 2008 12:19 PM To: [email protected] Subject: Re: Need help with a calc! Maybe: Case (Date ( start date ; start date ; start date +1 ) = End date; 0; (target hours - total hours) /8) On Feb 20, 2008, at 11:42 AM, Kim Parris wrote: If((Date(Month(start date), Day(start date), Year(start date) + 1)-1)=End date, 0 , If(target hours - total hours > 0 , (target hours - total hours) / ((365+ If((Date(Month(start date), Day(start date), Year(start date) +1)- start date + 1) = 366,1,0) - (End date - start date +1))*5/7),0))
