On Fri, 27 May 2005 14:29:48 +0100, "Bob Phillips"
wrote:

Hi Mangesh,

Thanks for the catch. Simplest solution is

=A1+A2+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A1+A2)))=5))+(--WEEKDAY(A1+
A2+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A1+A2)))=5)))=5)

Bob

Bob,

Your formula also seems to depend on the starting date NOT being on Thursday.

May 26, 2005 + 1 : should be May 27, 2005. Your formula gives May 28


--ron