Someone else made this calc for me and I thought it was working, but now I realize that it is not. I have gone over it and can't figure out how to fix it. The purpose is to find out how many hours they need to work on each business day to meet their target hours, based on their anniversary ( start and end dates)
Start date = 3/1/2007 End date = 2/20/2008 Target Hours = 1840 Total hours = 1791.6 The answer should be there are 8 business days left so (1840-1791.6) / 8 = 6.05. The current calc is coming up with 8.47. What am I missing? 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)) Thanks for your help! Kim
