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

"Mangesh Yadav" wrote in message
...
Hi Bob,

Today + 12 gives Thurday the 9th of June, instead of the next day.

Mangesh




"Bob Phillips" wrote in message
...
=A1+A2+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A1+A2)))=5))

where A1 is the date, A2 is the addition

--
HTH

Bob Phillips

"pankaj_zen" wrote in message
...

Hi all,
i have a unique problem.
here we have thursdays as week ends ( sat & sundays are working days).
Now what i want to do is in anexcel sheet if i enter say for example
enter 24 may which is tuesday in any of the cells & digit 5 in another
cell, when i add these two i should get 30 may i.e it should jump
thursday my weekly off.
the number can be any thing from1 to 70.

Can any one please help me in this regard?


--
pankaj_zen

------------------------------------------------------------------------
pankaj_zen's Profile: http://www.officehelp.in/member.php?userid=42
View this thread: http://www.officehelp.in/showthread.php?t=650962
Visit - http://www.officehelp.in |
http://www.officehelp.in/index/index.php/