Thank u sir,

the foll formula gives good results,
=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))

can u tell me were can i fit holidays or list of holidays in above formula to exclude holidays from the calculation.

thanks,



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com