On Feb 20, 2008, at 12:35 PM, 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))
I'm not following your condition, but if you remove the *5/7 it
returns the correct answer
i.e.
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)));0))
HTH
Lee