IF OR Fuction
Forum TopicHello All, Need a help.A formula to calulate the % duration complete based on IF OR function in excel Today = (D)28-May-22ItemABDuration% CompleteItem 123-May-2228-May-226B=D,100%, A<D,B>A,(D-A+1)/(B-A+1)Item 225-May-221-Jun-228 ThanksJithin