Hi Bob,

This is from one of the links given by Tom.

=$A$1+IF(B1=0,0,SIGN(B1)*SMALL(IF((WEEKDAY($A$1+SI GN(B1)*(ROW(INDIRECT("1:"&
ABS(B1)*10))),2)<4)*ISNA(MATCH($A$1+SIGN(B1)*(ROW (INDIRECT("1:"&ABS(B1)*10)
)),0,0)),ROW(INDIRECT("1:"&ABS(B1)*10))),ABS(B1)))

.....array formula


A1 is date
B1 is nos of days

Source: http://excelforum.com/showthread.php?t=376705


Mangesh



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

There still is a problem, now at 18 days and then 24, 25.
The problem is that, as you push forward, there is an accumulation further
down which the TO part (in the from:to range)
cannot handle.

Mangesh




"Bob Phillips" wrote in message
...
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/