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

Reply via email to